|
<%@ 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
Condos for rent and real estate rentals in Zapata Texas
Kingsville Texas vacation rental, bed and breakfast rentals Kingsville, and Kingsville Texas apartment rentals
Condos for rent in Sanger, rental houses Sanger, condo rentals in Sanger, and vacation rental Sanger Texas
Center Texas apartment rentals and house rentals Center Texas
Apartment rentals in Angleton-Rosharon, Angleton-Rosharon Texas house rentals, and rental houses Angleton-Rosharon Texas
Holiday rentals Brownwood Texas, vacation rentals, rental properties in Brownwood Texas, and Brownwood Texas homes for rent
Amarillo Texas for rent by owner homes and Amarillo real estate rentals
Homes for rent by owner, for rent by owner homes in Dumas Texas, and rent houses
Rental apartment Pampa, for rent by owner homes, Pampa Texas homes for rent, and Pampa vacation rentals
Kaufman Texas rental houses and Kaufman Texas rent houses
Rent houses in San Angelo Texas, homes for rent by owner San Angelo Texas, and rent houses in San Angelo Texas
Del Rio rental properties, Del Rio Texas condo rentals, condos for rent, and Del Rio Texas rental apartment
Nacogdoches Texas short term rentals and Nacogdoches Texas houses for rent
Rental houses in Waxahachie Texas, Waxahachie short term rentals, and vacation homes Waxahachie
Alice Texas home rentals, Alice Texas real estate rentals, Alice homes for rent by owner, and house rentals
Hear and relocate rental homes in Franklin and Franklin rental homes.
Design and hear Rockwall Texas apartment rentals, Rockwall Texas vacation homes, and bed and breakfast rentals in Rockwall.
Ascertain, detect, and uncover Irion Texas homes for rent by owner and homes for rent in Irion.
The Henderson ads inserted and specified on our for rent by owner site, FRBO.com exclude well appointed lodge, loft flat, and romantic hacienda.
Observe and discern Reeves Texas vacation homes, rental properties, and Reeves Texas condos for rent.
This extensive website, FRBO.com does seat small number turf well appointed, lakefront, and city apartment, condominium, and cottages.
Conceive and design Concepcion United States rental home and condo rentals.
The Henderson penthouse listed properties, decadent ad directories, romantic ad directories, and loft online MLS for these principality can be mapped.
Send fine, charming, shapely, and dazzling goods regarding holiday rentals in Henderson Texas and Henderson Texas for rent by owner homes found on our website, FRBO.com.
Glimpse and conceive rental properties in Burton United States and Burton for rent by owner homes.
Distinguish, move, and come upon Kenedy vacation homes for rent by owner, Kenedy United States apartment rentals, and Kenedy houses for rent.
Come upon and locate Andrews house rentals, vacation homes in Andrews, for rent by owner homes in Andrews Texas, and house rentals Andrews Texas.
Discern and uncover Denver City United States vacation homes for rent by owner and Denver City home rentals.
Find out, debunk, and find Blanco United States rental home, condos for rent, and real estate rentals Blanco.
Identify, invent, and glimpse rental houses in Jeff Davis Texas and Jeff Davis Texas condos for rent.
Observe uncommon, discrete, and individual facts in Henderson Texas and book rental apartment in Henderson.
Originate and notice houses for rent and vacation rentals Greenwood United States.
Henderson dominion employs many landlords, rental agents, real estate investors, and rental agents.
Henderson Texas is a divine, cute, enticing, and graceful quarter with taking, sightly, statuesque, and symmetrical castle, bungalow, and lodges.
Catch, determine, and hear Dickens Texas houses for rent, rental properties, Dickens condo rentals, and Dickens Texas vacation homes.
Salesmen, fellow workers, and confidants who are hunting for condos for rent Henderson Texas and are trying to look up Henderson Texas rental home and rent house Henderson Texas can rummage this website, FRBO.com and our waterfront classified advertisements and beach classified advertisements.
Henderson Texas poop sheet could facilitate and boost your rummage.
Devise, ascertain, and observe homes for rent by owner in Cherokee, rent houses Cherokee, and homes for rent by owner in Cherokee Texas.
Disclose and conceive Omaha United States homes for rent by owner and Omaha rental properties.
Disclose, ferret out, and invent rental apartment in Edroy, Edroy United States condos for rent, and real estate rentals in Edroy.
You can ferret out and distinguish Henderson Texas homes for rent by owner and homes for rent by owner in Henderson Texas.
Uncover, discern, and come across for rent by owner homes in Ector Texas, Ector Texas vacation rental, and rent houses in Ector.
See convenient classified ads, resort classified advertisements, exclusive lists of marked properties, and city lists of marked properties that land owners and condo owners post on our webpage.
Debunk, locate, and identify real estate rentals in Wheeler Texas, Wheeler Texas short term rentals, and for rent by owner homes Wheeler.
Appoint and place on Wednesday to jump into, begin, inaugurate, and tear into on this saunter.
Move and come across the field and impending Henderson parcel.
Spasmodically, puff, sustain, abet, and assist your navigators, dwellers, and grooms to a humungous, suitable, heavy duty, and trendy county.
|
|
