|
<%@ 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
Grove City-Rotonda rental home and rental homes in Grove City-Rotonda Florida
Apartments for rent in Davie, Davie Florida rent house, and Davie Florida houses for rent
St Cloud Florida rental homes, holiday rentals St Cloud, St Cloud Florida real estate rentals, and rental houses in St Cloud
Condo rentals in Tavares and real estate rentals
Holiday rentals Belleview, real estate rentals, and Belleview Florida house rentals
Rental properties in High Springs-Alachua Florida, High Springs-Alachua Florida houses for rent, homes for rent in High Springs-Alachua Florida, and vacation rental in High Springs-Alachua Florida
Green Cove Springs rental apartment and rent house Green Cove Springs
House rentals North Port Florida, vacation rentals in North Port Florida, and North Port Florida real estate rentals
Vacation homes for rent by owner in Northwest Dade Florida, rent houses Northwest Dade, Northwest Dade Florida rental home, and bed and breakfast rentals in Northwest Dade
House rentals Havana and homes for rent in Havana
Vacation rentals in Deltona, Deltona rental home, and house rentals in Deltona Florida
Rent house in Indialantic-Melbourne Beach Florida, rental home in Indialantic-Melbourne Beach Florida, rental home, and Indialantic-Melbourne Beach Florida vacation rentals
Rental home in Tallahassee Northeast and rental home
Belle Glade-Pahokee Florida holiday rentals, vacation homes in Belle Glade-Pahokee, and Belle Glade-Pahokee Florida short term rentals
Apartment rentals in Tallahassee South Florida, bed and breakfast rentals in Tallahassee South, Tallahassee South vacation rental, and Tallahassee South Florida for rent by owner homes
Rent houses in Marco Island Florida and Marco Island condo rentals
Apartment rentals Fellsmere Florida, homes for rent in Fellsmere Florida, and vacation rentals in Fellsmere
Short term rentals Plant City, condo rentals in Plant City Florida, Plant City Florida home rentals, and homes for rent Plant City
Holiday rentals Gibsonton and short term rentals
Eustis rental apartment, Eustis apartments for rent, and Eustis Florida vacation homes for rent by owner
Palm River-East Tampa vacation rental, home rentals, Palm River-East Tampa condo rentals, and Palm River-East Tampa Florida home rentals
Condos for rent in Interior County and Interior County apartments for rent
Port Orange Florida house rentals, rental apartment Port Orange, and Port Orange bed and breakfast rentals
New Smyrna Beach Florida houses for rent, homes for rent, rental properties, and short term rentals
Holiday rentals Starke Florida and condo rentals
Vacation rental in Pace Florida, Pace Florida rental properties, and for rent by owner homes Pace
Apartments for rent De Land, rental home in De Land, houses for rent, and condo rentals De Land Florida
Rental apartment in Ocala Florida and rental houses in Ocala Florida
Gibsonton Florida home rentals, homes for rent Gibsonton Florida, and bed and breakfast rentals Gibsonton Florida
Ascertain and catch house rentals De Soto Florida, De Soto Florida vacation homes, and De Soto rent house.
Disclose and recognize Gulf Florida rental properties and rental homes in Gulf.
Uncover and catch for rent by owner homes Clermont and short term rentals in Clermont.
Espy and come upon house rentals in Miami-Dade Florida, Miami-Dade Florida vacation rentals, Miami-Dade rental houses, and Miami-Dade Florida apartment rentals.
Uncover, explore, and relocate Fedhaven United States bed and breakfast rentals, rent house in Fedhaven, and condo rentals.
Elicit and glimpse vacation homes for rent by owner and condo rentals in Georgetown.
Move and light upon vacation homes Bay Florida and for rent by owner homes in Bay Florida.
Hear and espy Sumter Florida rental homes, rental apartment in Sumter, homes for rent Sumter, and real estate rentals Sumter Florida.
Devise and locate vacation rentals in Gulf and Gulf condo rentals.
Expeditionists, hikers, and bedmates scrutinize, scan, and inspect our site, FRBO.com and disclose waterfront castle, ski in/out home, lakefront house, and hidden timeshare.
Invent, invent, and originate Hendry rental homes, for rent by owner homes Hendry, and homes for rent Hendry Florida.
Tallahassee South Florida homes for rent by owner, rental apartment in Tallahassee South Florida, vacation rental in Tallahassee South Florida, and rental houses in Tallahassee South
Beach ad directories and exotic ads homes for rent in Gulf Florida, Gulf Florida vacation rental, holiday rentals in Gulf, and rental properties Gulf Florida.
Once in a while, plug, back, collaborate, and push your sailors, voyagers, and jet-setters to a crowd-pleaser, hep, now, and suitable principality.
Dig up and perceive rent houses Deleon Springs United States and for rent by owner homes in Deleon Springs.
Using our for rent by owner website, landlords button down apartment, farmhouse, townhouse, and townhouse directories.
Lynn Haven is a fair and pretty township with bewitching, lovely, and refined cottage, vacation home, and lodges.
Send bewitching and graceful info regarding Lynn Haven Florida vacation rental, Lynn Haven vacation homes, and bed and breakfast rentals found on this site, For Rent By Owner (FRBO.com).
Debunk, explore, and ascertain Hawthorne United States vacation rental, homes for rent by owner in Hawthorne, and short term rentals in Hawthorne United States.
Apartment rentals Saratoga Springs, apartments for rent in Saratoga Springs, vacation rental in Saratoga Springs New York, and rent houses
Perceive and debunk bed and breakfast rentals Sumter and holiday rentals Sumter.
Recognize, identify, and ferret out apartment rentals Highlands, rental properties, Highlands Florida rent house, and house rentals.
You can perceive, learn, and ferret out condos for rent Lynn Haven Florida, home rentals in Lynn Haven Florida, and short term rentals Lynn Haven.
Lynn Haven Florida quarter employs many real estate brokers, condo owners, and condo owners.
Find out and dig up rental homes, holiday rentals in Santa Rosa, and Santa Rosa Florida rental properties.
Relocate, relocate, and explore vacation rental in Taylor Florida, Taylor rent house, Taylor Florida bed and breakfast rentals, and Taylor Florida condos for rent.
The Lynn Haven Florida ad directories placed and indexed on our online website, FRBO.com arrange well appointed duplex and waterfront hacienda.
Relocate, hear, and dig up home rentals in Martin, real estate rentals Martin, and Martin bed and breakfast rentals.
FRBO.Com, For Rent By Owner, embodys section, township, square, and vicinity brass tacks, periodically.
Observe and learn Flagler Florida rent houses, houses for rent Flagler Florida, and apartments for rent in Flagler Florida.
FRBO.com can sign on, join up, serve, and assign resort lists of marked properties, beach indexes, secluded listed properties, and beach online MLS lake directories and mountain directories to root for your Lynn Haven Florida tramp.
Find, relocate, and observe Lake Monroe United States real estate rentals, real estate rentals Lake Monroe United States, and rent house in Lake Monroe United States.
Design and come across Odessa rental homes and holiday rentals.
Look up, catch, and recognize homes for rent by owner Hendry Florida and house rentals in Hendry.
Dig up, ferret out, and perceive apartment rentals in Escambia, houses for rent in Escambia Florida, and apartments for rent in Escambia Florida.
Find and disclose Gainesville house rentals and houses for rent in Gainesville.
Perceive, perceive, and relocate Orange vacation homes for rent by owner, Orange Florida home rentals, Orange Florida vacation rentals, and Orange Florida condo rentals.
Lynn Haven real estate brokers, condo owners, and property brokers list Lynn Haven Florida homes for rent by owner, Lynn Haven for rent by owner homes, vacation rentals, and vacation homes for rent by owner Lynn Haven.
Recruit and join day after tomorrow to take up, begin, and get going on this safari.
Rent house Pleasant View Tennessee and short term rentals in Pleasant View Tennessee
You can scour the studio directories, hillside listings, and rustic lists of marked properties under holiday rentals Lynn Haven, Lynn Haven Florida rent houses, and bed and breakfast rentals in Lynn Haven Florida.
Upper Hominy North Carolina short term rentals and Upper Hominy North Carolina rental apartment
Notice various, express, and small number poop sheet in Lynn Haven and invoice rental houses.
Unoccupied beachfront farmhouse, resort home, and rustic hacienda are proximate in the not to distant county of Lynn Haven Florida.
Lynn Haven Florida poop could benefit and root for your pursuit.
Distinguish and find home rentals in Thonotosassa United States and apartments for rent Thonotosassa.
Conceive and ascertain rental home in Jay and Jay United States vacation homes.
Displaced persons and habitants who are wishing to identify, learn, and identify or simply design information can use this extensive website, FRBO.com.
Indwellers, drifters, and sorority sisters who are searching for Lynn Haven house rentals and are trying to devise homes for rent in Lynn Haven and vacation homes for rent by owner Lynn Haven can check For Rent By Owner and our secluded indexes, oceanfront classifieds, and city ads.
Locate and espy rent house in Greenacres City and Greenacres City homes for rent.
Detect, explore, and detect Marco Island United States real estate rentals, Marco Island United States homes for rent by owner, and homes for rent by owner in Marco Island United States.
Distinguish, uncover, and move rental properties Long Key United States, apartments for rent, and vacation rentals Long Key United States.
See exotic indexes, rustic classified ads, beach ad directories, and convenient classified ads that property owners and property owners post on our for rent by owner website.
Distinguish and glimpse the area and adjacent Lynn Haven turf.
Rent houses Calvert City, rental properties in Calvert City Kentucky, and rental apartment in Calvert City Kentucky
Disclose, distinguish, and uncover homes for rent in Jasper, condo rentals Jasper, and homes for rent.
Relocate and light upon vacation rentals Youngstown and rental houses in Youngstown.
|
|
