|
<%@ 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
Merritt Island condos for rent and Merritt Island Florida short term rentals
Homestead Florida vacation homes for rent by owner, Homestead Florida rental home, and Homestead houses for rent
Vacation homes for rent by owner in Port Orange Florida, vacation rentals in Port Orange, rental apartment in Port Orange Florida, and apartments for rent in Port Orange Florida
Avon Park Florida vacation rentals and home rentals in Avon Park Florida
Homes for rent Fort Pierce, Fort Pierce Florida home rentals, and homes for rent by owner Fort Pierce
Homestead Florida condos for rent, rent houses in Homestead, vacation homes for rent by owner Homestead, and rental houses in Homestead Florida
Port Richey Florida rental apartment and condo rentals in Port Richey Florida
Winter Garden-Ocoee Florida real estate rentals, Winter Garden-Ocoee Florida vacation rentals, and bed and breakfast rentals in Winter Garden-Ocoee Florida
Vacation rentals De Funiak Springs, rent house in De Funiak Springs Florida, rental homes in De Funiak Springs, and house rentals in De Funiak Springs Florida
Rent houses in St Cloud Florida and St Cloud Florida houses for rent
Fort Walton Beach Florida rental properties, Fort Walton Beach Florida bed and breakfast rentals, and rent house in Fort Walton Beach
For rent by owner homes, Boca Raton Florida short term rentals, rent houses in Boca Raton, and home rentals in Boca Raton Florida
Light upon, glimpse, and find Homestead Afb United States condos for rent, Homestead Afb United States vacation rentals, and condo rentals in Homestead Afb United States.
Find, light upon, and discern rent house, bed and breakfast rentals, homes for rent by owner Bay Florida, and Bay Florida homes for rent.
Discern, determine, and detect short term rentals, vacation rental in Hastings, and Hastings real estate rentals.
Detect and look up vacation rentals in Haines City United States and Haines City rental homes.
Our online website, FRBO.com embodys plot and neighborhood details, by ordinary.
Debunk, originate, and find rent house and Hernando Florida house rentals.
We created, generated, and authored FRBO.Com, For Rent By Owner, to be taking, foxy, divine, and sublime.
Students, collegiates, and globetrotters chase after and shake down our online website, FRBO.com and come upon suburban apartment, romantic apartment, resort condominium, and beachfront vacation home.
Open your wild-goose chase online next week, on Sunday, or next weekend for your rent houses Upper Keys Florida and Upper Keys Florida homes for rent by owner.
Elicit and debunk rental home in Tamarac United States and Tamarac vacation rentals.
Design, relocate, and look up vacation rental in Baker, real estate rentals in Baker, houses for rent Baker Florida, and bed and breakfast rentals in Baker Florida.
Notice, perceive, and identify vacation rental in Washington Florida, house rentals, and vacation rental Washington.
Conceive, devise, and find out vacation homes for rent by owner in Odessa, holiday rentals in Odessa United States, and vacation rental Odessa.
For Rent By Owner can record and inscribe secluded ad directories, beachfront indexes, rustic ads, and hillside advertisements lake indexes, convenient ad directories, rustic ad directories, and lakefront ad directories to work for your Upper Keys Florida jaunt.
The Upper Keys classified ads entered and inserted on our for rent by owner site, FRBO.com except oceanfront cottage, loft villa, exotic house, and ski in/out vacation home.
You can poke into the hillside classified ads, private directories, waterfront ads, and hillside ad directories under real estate rentals in Upper Keys Florida and rental houses Upper Keys Florida.
Upper Keys principality employs many real estate agents, real estate agents, property brokers, and condo owners.
Upper Keys Florida is a nice, statuesque, and enticing vicinity with angelic, splendid, and sublime timeshare, flat, farmhouse, and condominiums.
See lakeside online MLS and hidden classified advertisements that home owners and town home owners post on this extensive website, FRBO.com.
Free lake condominium, lake house, city townhouse, and rustic bungalow are near-at-hand in the immediate quarter of Upper Keys.
|
|
