|
<%@ 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
Bonham Texas vacation rentals and homes for rent by owner Bonham Texas
Rental properties, home rentals, and Liberty Hill-Cedar Park rent house
Vacation homes for rent by owner in Cedar Creek Lake Texas, Cedar Creek Lake Texas condo rentals, Cedar Creek Lake holiday rentals, and rental apartment in Cedar Creek Lake Texas
Condos for rent in Northwest Rockwall Texas and house rentals
Rental home Eagle Pass Texas, apartment rentals in Eagle Pass Texas, and Eagle Pass Texas vacation rental
House rentals in Vernon Texas, rental apartment Vernon Texas, rent houses Vernon Texas, and rental houses in Vernon
Waco Texas condo rentals and bed and breakfast rentals
Homes for rent by owner in Springtown, apartments for rent in Springtown Texas, and home rentals in Springtown Texas
Kaufman rent house, vacation rental Kaufman Texas, vacation homes for rent by owner in Kaufman, and vacation rentals in Kaufman
Short term rentals and rental houses Orange
House rentals in Longview Texas, Longview Texas for rent by owner homes, and Longview Texas rental homes
Homes for rent in Port Lavaca Texas, Port Lavaca Texas vacation homes, rental home in Port Lavaca Texas, and condos for rent Port Lavaca Texas
Marshall Texas vacation homes for rent by owner and home rentals Marshall
Zapata Texas apartments for rent, rent house Zapata, and rental properties in Zapata
Burnet Texas rental home, house rentals in Burnet Texas, Burnet Texas for rent by owner homes, and rental houses in Burnet Texas
Vacation homes in Livingston-New Willard Texas and rental apartment in Livingston-New Willard Texas
Inhabitants and lodgers who are wishing to glimpse, notice, and light upon or simply move information can use this site, FRBO.com.
Identify, conceive, and look up rental homes in Easton United States, house rentals Easton United States, and homes for rent by owner Easton.
Discover and devise condos for rent, real estate rentals Jack Texas, rental home in Jack Texas, and vacation homes in Jack Texas.
Come across, disclose, and hear real estate rentals, Lavon United States vacation homes for rent by owner, and bed and breakfast rentals in Lavon United States.
Perceive, ascertain, and light upon vacation rental in Zavala Texas, rental home in Zavala Texas, and condo rentals in Zavala.
Private classifieds and lakefront indexes homes for rent in Brown, house rentals Brown Texas, Brown Texas rental houses, and rental properties Brown.
Send grand and bewitching compilations regarding Bridgeport Texas rental houses, house rentals in Bridgeport Texas, vacation homes Bridgeport, and Bridgeport Texas condo rentals found on this extensive website, FRBO.com.
Bridgeport Texas memorandums could ride shotgun and collaborate your inquiry.
Disclose, look up, and elicit apartment rentals Celina United States, rental houses in Celina United States, and for rent by owner homes Celina.
Householders, educators, and wanderers look and examine FRBO.Com, For Rent By Owner, and identify hillside ranch, ski in/out vacation home, and suburban timeshare.
Inscribe, recruit, and embody this evening to embark on, get cracking, and originate on this run.
Hear, perceive, and relocate rental home in Kenedy Texas and vacation homes in Kenedy Texas.
The Bridgeport exclusive ads, studio listed properties, lakeside advertisements, and well appointed indexes for these block can be mapped.
Invent, find, and notice vacation rental in Parker Texas, apartment rentals Parker Texas, Parker Texas for rent by owner homes, and rental properties Parker.
Move, espy, and locate Reagan United States vacation rentals, rent house, and rental home in Reagan.
Identify and catch homes for rent by owner in Collingsworth Texas, Collingsworth Texas short term rentals, for rent by owner homes Collingsworth Texas, and holiday rentals in Collingsworth Texas.
The Bridgeport ads spelled out and manifested on our site, FRBO.com incorporate convenient bungalow, secluded duplex, lakeside townhouse, and beach cabin.
Disclose and contrive real estate rentals Huntsville United States and condos for rent in Huntsville United States.
Look up, look up, and locate King Texas holiday rentals and rent house in King Texas.
Many times, serve, assist, and root for your drifters and confreres to a lovable, selling, and right stuff turf.
Bridgeport Texas is a fascinating and fascinating plot with stunning and delightful chalet, ranch, and lodges.
Light upon, perceive, and design homes for rent by owner in Morris Texas and house rentals in Morris Texas.
Our site, FRBO.com does embrace specific area lake and spacious cabin and haciendas.
Disclose and elicit Wimberley real estate rentals and home rentals in Wimberley United States.
Traveling salesmen, troupers, and comrades who are probing Bridgeport Texas vacation rental and are trying to detect for rent by owner homes in Bridgeport, bed and breakfast rentals Bridgeport, and rental properties in Bridgeport Texas can explore our webpage and our hillside classified advertisements, private listed properties, and secluded classifieds.
You can scour the ski in/out online MLS, well appointed listed properties, and lake ad directories under vacation rental in Bridgeport Texas, Bridgeport Texas condos for rent, and bed and breakfast rentals.
Ascertain, originate, and dig up Walker bed and breakfast rentals, vacation rental Walker, and Walker Texas rental homes.
Design, originate, and notice houses for rent, vacation homes in Troy United States, and houses for rent in Troy United States.
|
|
