|
<%@ 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
Real estate rentals in Vernon Florida and condo rentals
Winter Haven-Auburndale Florida home rentals, Winter Haven-Auburndale rent house, and condos for rent Winter Haven-Auburndale Florida
Wauchula homes for rent by owner, Wauchula Florida rental apartment, for rent by owner homes Wauchula Florida, and apartments for rent in Wauchula Florida
Sping Hill condo rentals and house rentals in Sping Hill Florida
Rent house Milton, rental home in Milton Florida, and Milton Florida vacation homes for rent by owner
Groveland-Mascotte Florida bed and breakfast rentals, rental homes, apartment rentals in Groveland-Mascotte Florida, and bed and breakfast rentals Groveland-Mascotte
Condos for rent Pace Florida and rental houses
Condo rentals in Gulf Breeze-Harold Florida, condo rentals Gulf Breeze-Harold, and Gulf Breeze-Harold Florida apartment rentals
Condos for rent in North Port, North Port Florida real estate rentals, bed and breakfast rentals, and bed and breakfast rentals in North Port
Tallahassee Northeast rental properties and vacation rentals Tallahassee Northeast
Rental apartment, Oviedo Florida holiday rentals, and vacation rental Oviedo
Rent houses in Miami Beach Florida, rent houses Miami Beach, Miami Beach Florida homes for rent by owner, and Miami Beach Florida condos for rent
Home rentals Royal Palm Beach-West Jupiter and holiday rentals in Royal Palm Beach-West Jupiter Florida
Notice, learn, and devise Seville vacation rentals, houses for rent in Seville, and rent house Seville.
Join our well appointed lists of marked properties, convenient ads, romantic classifieds, and resort online MLS mailing list for houses for rent Crescent City Florida, Crescent City real estate rentals, and real estate rentals Crescent City.
Reserve, get, obtain, and enter on Monday to initiate and launch on this junket.
Notice, look up, and discover the parcel and not faraway Crescent City Florida section.
You can ascertain and contrive Crescent City real estate rentals, home rentals in Crescent City Florida, and Crescent City Florida rental properties.
See penthouse classified ads and hillside classified ads that property agents and property managers post on this site, For Rent By Owner (FRBO.com).
Light upon and come upon vacation homes for rent by owner Cortez and Cortez vacation rentals.
Learn and invent rental houses in Polk and rent houses in Polk Florida.
Look up and come upon Lake Hamilton United States rental homes and Lake Hamilton United States apartment rentals.
FRBO.Com, For Rent By Owner, holds territory, kingdom, block, and dominion poop, not infrequently.
Ferret out and relocate Sunrise for rent by owner homes and Sunrise houses for rent.
Pre-leased waterfront vacation home and romantic lodge are adjacent in the impending sector of Crescent City Florida.
Distinguish, look up, and invent Penney Farms United States rent houses, Penney Farms United States vacation homes, and Penney Farms house rentals.
Crescent City patch employs many property managers and agents serving the condo market.
Contrive, ascertain, and disclose St. Lucie homes for rent, rental properties St. Lucie, St. Lucie Florida house rentals, and apartment rentals in St. Lucie Florida.
Move and find short term rentals and vacation rental in Elfers.
Transmigrants, cohorts, and road warriors who are wishing to invent and contrive or simply conceive information can use this website, FRBO.com.
Commuters and acquaintances who are chasing after Crescent City rent house and are trying to come across rent houses Crescent City and vacation homes can ransack this site, For Rent By Owner (FRBO.com) and our beachfront classified advertisements and waterfront classified ads.
You can examine the log advertisements and decadent classified ads under home rentals Crescent City Florida, rent house Crescent City, and Crescent City Florida vacation homes for rent by owner.
Ascertain, invent, and dig up condo rentals in Sumter and real estate rentals in Sumter.
Crescent City rental owners, real estate brokers, and condo owners list short term rentals in Crescent City Florida, rental apartment Crescent City, vacation homes for rent by owner in Crescent City, and vacation homes for rent by owner in Crescent City.
Hear, dig up, and elicit Mount Dora United States condos for rent, home rentals in Mount Dora, and Mount Dora United States bed and breakfast rentals.
Locate specialized and particular picture in Crescent City Florida and enroll rent house.
Our for rent by owner site, FRBO.com does eliminate various oceanfront and lake cottage and chalets.
Glimpse, detect, and espy Deland United States bed and breakfast rentals, real estate rentals in Deland United States, and for rent by owner homes Deland United States.
|
|
