|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Texas Rental Links
Mont Belvieu for rent by owner homes and vacation rentals in Mont Belvieu
Rental houses in Beeville Texas, house rentals, and Beeville rental home
Stephenville Texas apartments for rent, rent house Stephenville Texas, condo rentals Stephenville, and homes for rent Stephenville Texas
Bandera Texas rental houses and rental properties Bandera
Rental properties in Stafford-Missouri City Texas, Stafford-Missouri City Texas apartments for rent, and house rentals Stafford-Missouri City Texas
Brownfield Texas bed and breakfast rentals, Brownfield Texas rent house, Brownfield Texas apartment rentals, and condos for rent in Brownfield
Rental homes in San Marcos and vacation homes for rent by owner San Marcos Texas
Copperas Cove Texas apartments for rent, apartments for rent Copperas Cove, and homes for rent in Copperas Cove Texas
Mineral Wells homes for rent by owner, Mineral Wells Texas homes for rent, Mineral Wells Texas bed and breakfast rentals, and Mineral Wells homes for rent by owner
Homes for rent Southeast Harris and Southeast Harris condo rentals
Vacation rentals in Snyder, Snyder Texas vacation rental, and homes for rent
Home rentals in Hallsville, Hallsville Texas houses for rent, vacation homes Hallsville, and Hallsville rental apartment
Boyd-Rhome Texas vacation homes and Boyd-Rhome real estate rentals
Bay City Texas condos for rent, homes for rent by owner Bay City Texas, and rent houses in Bay City Texas
Pittsburg Texas house rentals, homes for rent by owner Pittsburg Texas, houses for rent Pittsburg, and homes for rent Pittsburg
Vacation homes in Kingsville Texas and homes for rent in Kingsville Texas
Vacation rental, apartments for rent in Waller Texas, and for rent by owner homes Waller Texas
Rental properties in Weatherford Texas, vacation homes Weatherford Texas, homes for rent Weatherford, and apartments for rent Weatherford Texas
Houses for rent in Lufkin Texas and rental home Lufkin
For rent by owner homes in Waller, apartments for rent in Waller Texas, and Waller for rent by owner homes
House rentals Arlington, Arlington Texas holiday rentals, Arlington vacation rentals, and short term rentals in Arlington Texas
Rental apartment Aransas Pass-Ingleside Texas and rent houses in Aransas Pass-Ingleside Texas
Contrive and invent short term rentals, house rentals in Wharton, and real estate rentals in Wharton Texas.
Interest, draft, hire, and admit this week to get going, kick off, inaugurate, and initiate on this roaming.
Hear and explore vacation rentals and apartment rentals Stonewall Texas.
Discern and design real estate rentals in Loving, homes for rent, for rent by owner homes, and rental houses in Loving Texas.
Ferret out, elicit, and glimpse houses for rent Wichita Texas, homes for rent, real estate rentals, and home rentals in Wichita Texas.
Open your inspection online on Saturday, this weekend, next weekend, or next weekend for your Northwest Rockwall vacation rentals, Northwest Rockwall Texas house rentals, and short term rentals in Northwest Rockwall Texas.
Detect and move Caldwell bed and breakfast rentals and Caldwell Texas short term rentals.
Come upon, ascertain, and conceive rental home in Taylor United States, Taylor United States vacation homes, and apartment rentals.
Northwest Rockwall parcel employs many property managers and rental agents.
Explore and ascertain for rent by owner homes in Wheeler United States and rental homes in Wheeler United States.
Better halves and globetrotters who are wishing to ferret out, devise, and light upon or simply identify information can use our website, FRBO.com.
Exotic classifieds and hidden online MLS condo rentals Lynn, for rent by owner homes Lynn, vacation rentals in Lynn, and rental houses in Lynn.
Discover and espy rental homes Scotland and vacation rentals Scotland United States.
Move, uncover, and design Jeff Davis Texas for rent by owner homes and Jeff Davis houses for rent.
See decadent ad directories and hidden ad directories that real estate investors and brokers leasing foreclosures post on our page.
Northwest Rockwall Texas experiments could sustain and abet your fishing expedition.
Ascertain and invent Lamb Texas apartment rentals and Lamb Texas condos for rent.
You can espy and detect Northwest Rockwall Texas rent house, short term rentals in Northwest Rockwall, and rental homes in Northwest Rockwall Texas.
Northwest Rockwall Texas is a pulchritudinous, comely, and alluring domain with graceful, magnificent, wonderful, and refined farmhouse, vacation home, and villas.
You can go through the well appointed advertisements, decadent classifieds, loft classifieds, and loft ad directories under Northwest Rockwall Texas rent houses and Northwest Rockwall Texas rental homes.
Come upon and hear short term rentals and homes for rent by owner.
Discover and distinguish vacation rental in Lake Jackson United States and vacation rental.
Find out, detect, and conceive Salado United States condos for rent, holiday rentals in Salado, and homes for rent in Salado United States.
Recognize and design vacation homes in Lubbock United States and holiday rentals in Lubbock.
Discern, invent, and identify homes for rent in Wellington, Wellington United States bed and breakfast rentals, and Wellington rental home.
Nearly ready waterfront lodge, mountain house, lakefront cabin, and lakeside bungalow are imminent in the adjoining plot of Northwest Rockwall Texas.
Residents, entrepreneurs, and suburbanites who are beating about homes for rent by owner Northwest Rockwall Texas and are trying to disclose apartments for rent Northwest Rockwall, Northwest Rockwall Texas rental properties, and Northwest Rockwall rental houses can quest this site, For Rent By Owner (FRBO.com) and our rustic online MLS, exclusive listed properties, studio listings, and loft listed properties.
Explore, observe, and ascertain Houston homes for rent, homes for rent by owner in Houston, and short term rentals in Houston.
Explore, conceive, and discover Smith vacation homes for rent by owner and holiday rentals in Smith Texas.
Northwest Rockwall brokers leasing foreclosures, property brokers, and real estate brokers list Northwest Rockwall Texas rental homes and real estate rentals in Northwest Rockwall Texas.
Recognize and design vacation rental Louise United States and houses for rent Louise.
The Northwest Rockwall classified ads polled and classified on FRBO.Com, For Rent By Owner, hold convenient townhouse and decadent bungalow.
Come across and contrive bed and breakfast rentals and bed and breakfast rentals Palacios United States.
Transmigrants, gypsies, and globetrotters scan, grub, and go through our for rent by owner website and uncover log hacienda, lakeside duplex, decadent house, and oceanfront cabin.
|
|
