Here is the code:

```
public class Main extends Activity {

/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);

    // Find your views
    final ListView listPro = (ListView) findViewById(R.id.listProperty);

    DBAdapter db = new DBAdapter(this);

    db.open();

    final Cursor c = db.getAllProperties();
    startManagingCursor(c);

    // Create the adapter
    MainAdapter adapter = new MainAdapter(this, c);
    listPro.setAdapter(adapter);

    // here is where I think I should put the code to select the row but I 
            // haven't been able to figure out how to do it.
            // all I need to get out is the row id number.. please help

    Button addPropBut = (Button) findViewById(R.id.mainButton);
    addPropBut.setOnClickListener(new OnClickListener() {

        public void onClick(View v) {

            Intent i7 = new Intent(Main.this, Home.class);
            startActivity(i7);

        }

    });
}

}

```