|
<%@ 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
Labelle rental home and vacation rental Labelle Texas
Apartments for rent, rent houses in Kaufman Texas, and rental properties in Kaufman
Apartment rentals, real estate rentals Lamesa, Lamesa Texas apartments for rent, and Lamesa real estate rentals
Silsbee Texas short term rentals and Silsbee Texas for rent by owner homes
Apartments for rent in Midlothian Texas, house rentals Midlothian, and Midlothian Texas rental home
Apartment rentals Edcouch-Elsa Texas, holiday rentals in Edcouch-Elsa Texas, Edcouch-Elsa Texas homes for rent, and rent house Edcouch-Elsa Texas
Weatherford Southeast Texas holiday rentals and Weatherford Southeast Texas rental apartment
Snyder Texas apartments for rent, vacation rental Snyder, and homes for rent by owner in Snyder Texas
Bed and breakfast rentals, Chance-Loeb Texas vacation rentals, Chance-Loeb Texas for rent by owner homes, and rental properties
Rental properties in Rockport Texas and condo rentals in Rockport Texas
Homes for rent, real estate rentals, and El Campo condo rentals
Corsicana home rentals, Corsicana Texas apartment rentals, rental apartment, and homes for rent
Rent house in Liberty-Dayton Texas and Liberty-Dayton Texas holiday rentals
Vacation homes in Pleasanton Texas, Pleasanton real estate rentals, and apartment rentals Pleasanton
Laredo Texas vacation homes, Laredo Texas apartments for rent, for rent by owner homes in Laredo Texas, and Laredo rental apartment
New Boston Texas for rent by owner homes and homes for rent by owner in New Boston Texas
Zapata home rentals, Zapata Texas home rentals, and apartments for rent in Zapata
Georgetown-Round Rock Texas for rent by owner homes, Georgetown-Round Rock Texas rent house, rental apartment in Georgetown-Round Rock Texas, and vacation homes Georgetown-Round Rock
Northeast Texas short term rentals and Northeast Texas vacation rentals
Rent house in Southeast Montgomery, rental home, and vacation rentals
You can inspect the oceanfront listed properties, waterfront classified advertisements, and exclusive ad directories under Fulshear-Simonton rental properties, Fulshear-Simonton Texas homes for rent by owner, and rental properties Fulshear-Simonton Texas.
Our site, FRBO.com does have unconventional vicinity decadent, lake, studio, and log cabin and farmhouses.
Discover, hear, and discover Perry United States vacation rental, Perry United States vacation homes for rent by owner, and Perry United States apartment rentals.
Identify and espy rental homes and Teague United States rental homes.
Conscribe, muster, procure, and draft on Friday to enter upon, get cracking, tear into, and get going on this roaming.
Loft lists of marked properties and beach classified advertisements home rentals in Jim Wells, vacation homes for rent by owner Jim Wells, Jim Wells homes for rent, and real estate rentals Jim Wells Texas.
Espy and explore Orange Grove United States real estate rentals and apartments for rent in Orange Grove United States.
Recently available hidden timeshare, spacious timeshare, romantic hacienda, and resort castle are abutting in the contiguous turf of Fulshear-Simonton Texas.
Look up and find out homes for rent by owner in Zavala Texas, homes for rent by owner Zavala Texas, and homes for rent by owner in Zavala Texas.
See lakeside listed properties and studio ad directories that real estate investors and agents serving the condo market post on FRBO.com.
Light upon, disclose, and uncover rental apartment in Kingsland, condo rentals Kingsland United States, and house rentals in Kingsland United States.
Detect and distinguish bed and breakfast rentals Cedar Lane United States and for rent by owner homes Cedar Lane United States.
Uncover and relocate homes for rent by owner Live Oak Texas and homes for rent by owner Live Oak Texas.
Ferret out and espy the township and immediate Fulshear-Simonton territory.
Locate and discover Itasca condo rentals and Itasca United States condos for rent.
Fulshear-Simonton Texas is a charming and statuesque zone with stunning, graceful, appealing, and ravishing farmhouse and duplexs.
Espy, detect, and ferret out rent house in Los Ebanos United States, Los Ebanos rent houses, and homes for rent by owner Los Ebanos.
Roamers and globetrotters go through, ferret, and check this extensive website, FRBO.com and distinguish lake house and hidden hacienda.
Fulshear-Simonton brokers leasing foreclosures, home owners, and brokers leasing foreclosures list Fulshear-Simonton Texas condos for rent, Fulshear-Simonton Texas house rentals, Fulshear-Simonton Texas rent houses, and vacation rental in Fulshear-Simonton Texas.
Look up and move Kent vacation rental and house rentals in Kent Texas.
Notice, design, and disclose Delta short term rentals, homes for rent by owner Delta Texas, rental properties in Delta, and rental apartment.
|
|
