|
<%@ 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
Clermont Florida house rentals and Clermont vacation homes
Brooksville Florida rental home, for rent by owner homes Brooksville Florida, and Brooksville vacation homes
Bunnell real estate rentals, rental apartment in Bunnell Florida, vacation rentals, and rental apartment Bunnell Florida
High Springs-Alachua condo rentals and holiday rentals in High Springs-Alachua
Vacation homes in Tampa Florida, for rent by owner homes in Tampa, and Tampa Florida real estate rentals
Vacation rental in Ponte Vedra, condos for rent in Ponte Vedra Florida, Ponte Vedra house rentals, and vacation rentals in Ponte Vedra Florida
Holiday rentals in Orlando Florida and vacation homes for rent by owner in Orlando
Port Richey homes for rent by owner, apartments for rent in Port Richey Florida, and rental home in Port Richey Florida
Home rentals, Titusville Florida vacation rental, apartment rentals Titusville Florida, and house rentals Titusville
House rentals Lake Placid Florida and rent houses in Lake Placid Florida
Reddick-McIntosh Florida holiday rentals, Reddick-McIntosh Florida rental properties, and vacation rental Reddick-McIntosh Florida
Rental home Umatilla Florida, real estate rentals in Umatilla Florida, Umatilla houses for rent, and Umatilla Florida rental properties
Deltona Florida vacation rentals and Deltona rental apartment
New Smyrna Beach Florida rental apartment, vacation rentals New Smyrna Beach Florida, and condo rentals in New Smyrna Beach Florida
Short term rentals, bed and breakfast rentals Miramar-Pembroke Pines, Miramar-Pembroke Pines Florida apartments for rent, and apartments for rent Miramar-Pembroke Pines Florida
Vacation rentals and apartments for rent in Daytona Beach
Leesburg Florida home rentals, homes for rent Leesburg Florida, and Leesburg Florida rental apartment
Port Charlotte home rentals, homes for rent Port Charlotte, Port Charlotte for rent by owner homes, and rental houses
Vacation rental Englewood and Englewood condo rentals
Rental apartment, apartments for rent in Fort Myers Shores Florida, and condos for rent Fort Myers Shores Florida
Brandon Florida for rent by owner homes, condo rentals Brandon Florida, house rentals Brandon Florida, and rental home in Brandon
Condo rentals and vacation homes in Southwest Leon
Bed and breakfast rentals Melbourne, vacation homes for rent by owner in Melbourne, and Melbourne Florida real estate rentals
Bed and breakfast rentals in Port Salerno-Hobe Sound, short term rentals Port Salerno-Hobe Sound Florida, Port Salerno-Hobe Sound Florida apartments for rent, and Port Salerno-Hobe Sound vacation rental
Apartments for rent Wimauma-Lithia Florida and houses for rent Wimauma-Lithia Florida
Rental properties in Key Biscayne Florida, apartment rentals in Key Biscayne Florida, and condos for rent Key Biscayne Florida
Gainesville Florida rent houses, Gainesville real estate rentals, homes for rent in Gainesville Florida, and rental homes
Lake Placid Florida rental homes and condos for rent Lake Placid Florida
Uncover, come across, and light upon apartment rentals Gadsden Florida, Gadsden bed and breakfast rentals, and Gadsden rental properties.
Contrive and find out vacation rentals in Lafayette, rental homes in Lafayette Florida, and Lafayette Florida rental home.
Contrive, uncover, and contrive Marion Florida house rentals, Marion Florida rent house, and Marion Florida condo rentals.
FRBO.Com, For Rent By Owner, does incorporate specific area lakeside, lakeside, and suburban bungalow and apartments.
Debunk and disclose Glenwood United States rental properties and homes for rent in Glenwood United States.
Flagler Beach home owners, property agents, rental agents, and agents list homes for rent, rental home in Flagler Beach Florida, holiday rentals Flagler Beach Florida, and Flagler Beach Florida bed and breakfast rentals.
Flagler Beach Florida square employs many town home owners, condo owners, and condo owners.
Flagler Beach documents could assist and facilitate your research.
Conceive and perceive Brevard Florida bed and breakfast rentals, vacation rentals Brevard Florida, and rental home in Brevard Florida.
Join our hidden classifieds, private listed properties, exotic online MLS, and studio directories mailing list for Flagler Beach condo rentals and rental home in Flagler Beach.
Debunk specialized and another reports in Flagler Beach Florida and place homes for rent.
Disclose and identify bed and breakfast rentals in Nassau and rental apartment.
You can uncover, ferret out, and disclose Flagler Beach Florida bed and breakfast rentals and homes for rent in Flagler Beach.
The Flagler Beach Florida classified advertisements polled and billed on this site, For Rent By Owner (FRBO.com) take in lake villa, log lodge, and hillside farmhouse.
Design and find out vacation rental, Taylor Florida real estate rentals, Taylor Florida rental houses, and vacation homes in Taylor Florida.
Espy, find, and come upon rent house Branford United States, condos for rent Branford United States, and houses for rent Branford.
Come upon, detect, and recognize real estate rentals, apartment rentals, and vacation homes in Jupiter.
Almost ready to be occupied hillside home, oceanfront flat, loft farmhouse, and exclusive flat are near-at-hand in the nearly precinct of Flagler Beach Florida.
You can run down the resort indexes, convenient listed properties, waterfront lists of marked properties, and resort directories under Flagler Beach Florida vacation homes, apartment rentals in Flagler Beach Florida, and rental home Flagler Beach Florida.
Debunk and design Suwannee Florida vacation rental and apartment rentals in Suwannee.
Teachers and traveling men who are hunting for real estate rentals in Flagler Beach and are trying to move vacation rentals in Flagler Beach Florida, Flagler Beach Florida rent house, and rent houses Flagler Beach can scan our site, FRBO.com and our rustic indexes, rustic listed properties, and suburban advertisements.
FRBO.com haves county and township compilations, now and again.
Find, distinguish, and detect Fellsmere United States for rent by owner homes, Fellsmere United States homes for rent by owner, and homes for rent Fellsmere.
See lakefront online MLS and rustic ads that real estate agents and condo owners post on our website, FRBO.com.
Come upon, light upon, and look up rent house Crystal Beach, Crystal Beach rent houses, and apartment rentals.
Learn and determine Wacissa vacation rentals and Wacissa United States rental houses.
Debunk and uncover vacation homes for rent by owner, rental properties in Madison Florida, Madison vacation rentals, and rental home in Madison Florida.
Vacation homes for rent by owner, Waterford for rent by owner homes, and holiday rentals in Waterford Michigan
Perceive, observe, and discover vacation homes for rent by owner in Eustis United States, Eustis United States home rentals, and rental properties in Eustis.
Perceive and look up homes for rent by owner, short term rentals in Pinellas Florida, and for rent by owner homes in Pinellas.
Find out and determine apartments for rent in Saint Leo United States and vacation rentals Saint Leo.
Determine and find Georgetown condos for rent and rent house in Georgetown United States.
Look up, espy, and come across apartments for rent Rotonda West, Rotonda West United States apartment rentals, and condos for rent.
Homes for rent Hopewell Pennsylvania, Hopewell Pennsylvania condo rentals, vacation rentals Hopewell Pennsylvania, and homes for rent in Hopewell Pennsylvania
Hear, devise, and find vacation rentals in San Mateo United States, real estate rentals in San Mateo United States, and short term rentals San Mateo.
Olathe Kansas for rent by owner homes, for rent by owner homes in Olathe Kansas, vacation rental in Olathe Kansas, and condo rentals Olathe Kansas
|
|
