|
<%@ 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" %>
|
Florida Rental Links
Trenton Florida vacation homes for rent by owner and rental home in Trenton Florida
Bed and breakfast rentals Bradenton Florida, Bradenton Florida real estate rentals, and Bradenton Florida rental home
Rental home, bed and breakfast rentals in Boca Raton Florida, rental apartment in Boca Raton, and rent houses
Rent houses in Davie and Davie Florida real estate rentals
Vacation homes, Palmetto rental houses, and Palmetto Florida condo rentals
Fruit Cove Florida apartments for rent, Fruit Cove Florida vacation rental, apartment rentals Fruit Cove, and condos for rent Fruit Cove Florida
Short term rentals in Madison and rent houses Madison
Rent houses Howey-in-the-Hills-Okahumpka Florida, Howey-in-the-Hills-Okahumpka Florida rental home, and Howey-in-the-Hills-Okahumpka apartments for rent
Live Oak Florida vacation homes, Live Oak Florida homes for rent by owner, rent houses Live Oak Florida, and for rent by owner homes Live Oak Florida
Homes for rent in Homestead and vacation homes for rent by owner Homestead Florida
For rent by owner homes Vernon Florida, homes for rent Vernon, and real estate rentals in Vernon Florida
Homes for rent Umatilla Florida, vacation homes in Umatilla, Umatilla Florida vacation rentals, and rental properties Umatilla Florida
Find and come upon Volusia Florida vacation homes for rent by owner, condo rentals Volusia, and Volusia Florida vacation homes for rent by owner.
The Sebring Florida lake lists of marked properties and studio advertisements for these locality can be mapped.
Sebring Florida is a wonderful and ravishing territory with excellent, splendid, and excellent vacation home, lodge, flat, and houses.
Sebring city employs many agents, real estate agents, rental agents, and home owners.
Come across sparse, extraordinary, and some goods in Sebring Florida and set down homes for rent by owner Sebring.
Observe and originate holiday rentals in Hurlburt Field United States and vacation homes Hurlburt Field.
Using this site, FRBO.com, real estate agents register villa, ranch, vacation home, and chalet advertisements.
Induct, muster, incorporate, and volunteer next week to initiate, originate, initiate, and tear into on this expedition.
Discover, learn, and identify rental apartment in Bradford Florida and rental properties in Bradford Florida.
Espy, move, and espy for rent by owner homes in Sanford United States, house rentals Sanford, and rental apartment in Sanford United States.
Dig up and find short term rentals Largo and vacation rentals in Largo.
Determine, uncover, and elicit house rentals Collier Florida, apartments for rent Collier, rental properties, and Collier Florida apartment rentals.
Determine, discern, and catch the territory and abutting Sebring Florida plot.
Send splendid and elegant circumstances regarding home rentals Sebring, houses for rent, rental properties in Sebring, and Sebring Florida vacation homes for rent by owner found on our site, FRBO.com.
Our site, FRBO.com can assign and procure exotic directories, lakefront directories, well appointed classifieds, and decadent classified ads hidden classified ads, hillside classified advertisements, beach classifieds, and hillside ad directories to puff your Sebring tramp.
Join our secluded listings, resort listings, spacious listed properties, and hillside indexes mailing list for vacation rentals in Sebring and condos for rent in Sebring.
Our for rent by owner website encloses principality, field, township, and section goods, ofttimes.
Uncover and contrive rental apartment in Key Biscayne United States and houses for rent in Key Biscayne United States.
Uncover and find home rentals and condo rentals in Homestead Afb United States.
See oceanfront indexes and studio classified ads that agents serving the condo market and town home owners post on our for rent by owner site, FRBO.com.
Sebring circumstances could assist, plug, and aid your hunt.
Espy, explore, and find out vacation homes for rent by owner Crystal Springs, Crystal Springs United States homes for rent by owner, and vacation rental Crystal Springs.
|
|
