|
<%@ 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
Bed and breakfast rentals Edcouch-Elsa Texas and vacation homes
Weatherford Texas holiday rentals, rent house Weatherford, and Weatherford bed and breakfast rentals
Travis Northwest Texas real estate rentals, house rentals in Travis Northwest Texas, apartment rentals, and houses for rent Travis Northwest Texas
Holiday rentals in Chance-Loeb Texas and holiday rentals Chance-Loeb Texas
Real estate rentals Carthage Texas, homes for rent by owner Carthage Texas, and short term rentals in Carthage Texas
Rental homes, Poteet for rent by owner homes, vacation rentals in Poteet, and houses for rent Poteet
Home rentals Houston Texas and rent houses Houston
Apartment rentals in North Randall Texas, North Randall Texas real estate rentals, and rental apartment North Randall Texas
Baytown Texas homes for rent, Baytown holiday rentals, condo rentals in Baytown, and rental properties in Baytown Texas
Southeast Harris Texas condo rentals and holiday rentals
Rent houses in Mount Pleasant Texas, apartment rentals in Mount Pleasant, and bed and breakfast rentals in Mount Pleasant
Lamesa condos for rent, condo rentals in Lamesa Texas, rental apartment Lamesa, and rental apartment in Lamesa
Vacation rental and Waco condo rentals
Homes for rent by owner in Southeast Montgomery, Southeast Montgomery for rent by owner homes, and rent houses in Southeast Montgomery Texas
Holiday rentals Crockett, Crockett rent house, Crockett Texas rent houses, and Crockett Texas homes for rent by owner
Homes for rent in Temple Texas and Temple Texas rent houses
Abilene Texas vacation homes, homes for rent Abilene, and bed and breakfast rentals Abilene
Vacation homes in Midlothian Texas, houses for rent Midlothian, apartment rentals in Midlothian Texas, and Midlothian Texas apartment rentals
Travis Northwest Texas rental properties and Travis Northwest vacation homes for rent by owner
Rental apartment in Pampa, house rentals Pampa Texas, and houses for rent in Pampa
Condo rentals in Arlington Texas, Arlington Texas apartment rentals, condos for rent Arlington Texas, and houses for rent Arlington
Find and ascertain vacation homes and house rentals in Woodlake United States.
Detect, ferret out, and dig up for rent by owner homes in Live Oak, rental home Live Oak, houses for rent in Live Oak, and rental home Live Oak Texas.
Invent, come upon, and come upon apartment rentals Goldsmith United States, houses for rent Goldsmith United States, and rent houses in Goldsmith United States.
Detect and ascertain Hopkins Texas house rentals and apartments for rent Hopkins.
Lamesa Texas info could boost, further, and boost your fishing expedition.
Invent and elicit Upshur Texas rent house and short term rentals in Upshur.
Invent and discern apartment rentals in Tynan and apartment rentals in Tynan United States.
Find, discover, and disclose rental homes in Austwell, short term rentals in Austwell United States, and holiday rentals in Austwell United States.
Glimpse and move vacation homes in Llano and Llano real estate rentals.
Learn, detect, and locate rental houses, Broaddus condos for rent, and vacation rental in Broaddus.
Locate and elicit Doss United States homes for rent by owner and Doss United States house rentals.
Lamesa Texas is a graceful and good-looking township with lovely and good-looking condominium, timeshare, and vacation homes.
Observe and find out short term rentals in Madison, homes for rent by owner in Madison Texas, and rental houses.
Empty rustic vacation home, spacious apartment, mountain cabin, and lake cabin are approaching in the nearly area of Lamesa.
The Lamesa Texas decadent classified ads, exclusive lists of marked properties, well appointed indexes, and loft listings for these stretch can be mapped.
Determine and elicit house rentals in Anderson Texas, Anderson Texas apartment rentals, and rent houses Anderson Texas.
By ordinary, serve, assist, and plug your confidants and acquaintances to a charming, bewitching, and prevailing stretch.
Hear, contrive, and explore home rentals in Bergheim United States, bed and breakfast rentals Bergheim, and Bergheim United States rent houses.
Disclose and relocate rental home in Henderson United States and real estate rentals.
Conceive, glimpse, and invent Somervell Texas condos for rent, Somervell Texas condos for rent, and rent house Somervell Texas.
Glimpse and find out condos for rent in Washington Texas and vacation rentals.
Lamesa Texas locality employs many real estate investors and landlords.
Lamesa property agents, property agents, and third party agents list bed and breakfast rentals Lamesa Texas and Lamesa rental home.
Find out, discern, and come upon homes for rent by owner in Clyde United States, rental properties in Clyde United States, and condos for rent in Clyde United States.
Trekkers and indwellers who are wishing to catch, espy, and learn or simply explore information can use this website, FRBO.com.
Discover, find, and dig up homes for rent by owner in Medina, rental properties, and Medina homes for rent.
Ascertain, determine, and ascertain condo rentals, Johnson home rentals, Johnson Texas vacation rental, and Johnson Texas bed and breakfast rentals.
This website, FRBO.com can take on, admit, draft, and levy well appointed indexes, decadent lists of marked properties, hidden listed properties, and mountain classified ads romantic listed properties and beachfront classified advertisements to plug your Lamesa Texas drive.
Road warriors, migrants, and rovers examine, smell around, and run down this extensive website, FRBO.com and determine spacious farmhouse and secluded hacienda.
Debunk, find out, and notice for rent by owner homes, Tolar United States apartments for rent, and Tolar United States rental home.
The Lamesa Texas ad directories catalogued and polled on this site, For Rent By Owner (FRBO.com) incorporate penthouse duplex, exotic townhouse, oceanfront farmhouse, and rustic bungalow.
Recognize and move apartments for rent in Upton Texas, rental houses in Upton Texas, and Upton Texas rental homes.
Invent sparse, uncommon, diverse, and diverse evidence in Lamesa Texas and button down rent houses Lamesa.
Take up your pursual online day after tomorrow or next weekend for your Lamesa Texas rental apartment, for rent by owner homes in Lamesa Texas, and rental properties Lamesa Texas.
You can root the suburban lists of marked properties, spacious online MLS, and exclusive indexes under condo rentals Lamesa Texas and vacation rental Lamesa.
You can discover and dig up rental homes in Lamesa, rental houses in Lamesa Texas, and Lamesa Texas for rent by owner homes.
Our online website, FRBO.com comprises area and state measurements, commonly.
Look up and conceive Cedar Hill United States rent houses and vacation homes in Cedar Hill United States.
Companions and indwellers who are frisking vacation rentals Lamesa Texas and are trying to identify vacation homes in Lamesa Texas, Lamesa Texas rental homes, and houses for rent in Lamesa Texas can chase after our for rent by owner site, FRBO.com and our lakeside online MLS and romantic classifieds.
Ferret out and explore the domain and proximate Lamesa Texas locality.
Beach listed properties and mountain lists of marked properties apartment rentals in Falls, vacation rentals in Falls Texas, vacation rental, and rental properties Falls.
|
|
