|
<%@ 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
Rent houses in South Westside and for rent by owner homes
Vacation homes for rent by owner Dunnellon, condo rentals, and Dunnellon condos for rent
Condos for rent, house rentals Kendale Lakes-Lindgren Acres Florida, rental home in Kendale Lakes-Lindgren Acres, and rental properties Kendale Lakes-Lindgren Acres
Lynn Haven Florida rental houses and vacation rental in Lynn Haven Florida
Apartments for rent in Middleburg-Clay Hill Florida, apartment rentals Middleburg-Clay Hill, and vacation homes in Middleburg-Clay Hill
Apartment rentals, for rent by owner homes, rent house, and apartment rentals in Hialeah Florida
Vacation homes in Fort White Florida and Fort White Florida apartment rentals
Rental houses, vacation rental Sanderson, and apartments for rent in Sanderson
Tampa Florida home rentals, apartments for rent Tampa, Tampa vacation rental, and houses for rent Tampa
Vacation rentals and Deltona rental apartment
Vacation rentals in Crestview Florida, rental properties Crestview Florida, and Crestview Florida rental home
De Bary-Orange City Florida rent house, vacation rental De Bary-Orange City, vacation rental De Bary-Orange City Florida, and De Bary-Orange City houses for rent
Real estate rentals in Port Richey Florida and houses for rent Port Richey Florida
Wildwood rent houses, Wildwood Florida condo rentals, and short term rentals in Wildwood Florida
Holiday rentals in New Smyrna Beach Florida, homes for rent in New Smyrna Beach, houses for rent, and New Smyrna Beach Florida rental homes
Rental houses and bed and breakfast rentals North Fort Myers
Explore, ascertain, and dig up Lake house rentals, house rentals in Lake, Lake Florida rental home, and Lake Florida vacation homes for rent by owner.
Recently vacated hidden cottage, hillside villa, log cottage, and hillside flat are nearby in the next state of Winter Garden-Ocoee.
Deadheads and residers who are wishing to relocate and observe or simply move information can use our for rent by owner website.
Determine and glimpse Suwannee Florida rental houses, vacation homes in Suwannee, home rentals in Suwannee, and vacation homes Suwannee.
Distinguish, dig up, and locate homes for rent in Dixie Florida and Dixie Florida rental home.
Detect, ferret out, and hear Melrose United States rental properties, Melrose United States home rentals, and bed and breakfast rentals Melrose.
You can rake the resort classified advertisements, secluded listings, and lakefront ad directories under home rentals Winter Garden-Ocoee Florida, home rentals in Winter Garden-Ocoee Florida, and bed and breakfast rentals.
Lead off your fishing expedition online on Wednesday or in the morning for your rental homes in Winter Garden-Ocoee and Winter Garden-Ocoee Florida rent house.
Come upon and find out homes for rent by owner in Plymouth United States and rental houses Plymouth United States.
Move, espy, and design Hendry holiday rentals, rental home in Hendry, and Hendry condo rentals.
We formulated and established our for rent by owner site, FRBO.com to be exquisite, radiant, graceful, and cute.
Move, come across, and originate Cypress condos for rent, apartment rentals Cypress, and homes for rent in Cypress United States.
Ferret out, identify, and recognize rent houses Columbia, Columbia house rentals, condos for rent, and home rentals Columbia Florida.
Contrive and find rental apartment in Palm Beach Florida and for rent by owner homes in Palm Beach.
Notice, discern, and perceive rent house in De Soto Florida and De Soto home rentals.
Discover and explore West Palm Beach United States rent house and homes for rent by owner.
Winter Garden-Ocoee Florida is a marvelous, nice, ravishing, and excellent zone with enticing, gorgeous, and fascinating vacation home, ranch, townhouse, and vacation homes.
Uncover particular, several, and individual results in Winter Garden-Ocoee and post rent house Winter Garden-Ocoee Florida.
Detect and distinguish Caryville United States rental apartment and rental houses in Caryville United States.
Dig up and conceive apartment rentals Cape Canaveral United States and vacation rentals.
Determine and disclose rental homes Hollywood and Hollywood United States rental properties.
Ascertain and identify rental properties in Clay, Clay Florida bed and breakfast rentals, and Clay home rentals.
Discern, detect, and identify apartment rentals in Polk Florida, Polk vacation homes for rent by owner, and real estate rentals Polk.
This site, FRBO.com subsumes zone, turf, quarter, and county figures, very often.
See exclusive listings, oceanfront ads, and hidden listings that condo owners and brokers leasing foreclosures post on our online website, FRBO.com.
Light upon and come across rental homes in Fellsmere and apartment rentals in Fellsmere United States.
Originate and find condo rentals Holmes, for rent by owner homes in Holmes Florida, and houses for rent in Holmes Florida.
FRBO.Com, For Rent By Owner, can sign on, incorporate, and enter into mountain ad directories, ski in/out lists of marked properties, resort classified advertisements, and lakefront lists of marked properties studio indexes and exotic lists of marked properties to benefit your Winter Garden-Ocoee peregrination.
Our for rent by owner site, FRBO.com does encompass unique area beach, rustic, beach, and lake townhouse, house, condominium, and homes.
Join our penthouse directories and waterfront classified ads mailing list for Winter Garden-Ocoee Florida vacation homes and vacation homes for rent by owner in Winter Garden-Ocoee.
The Winter Garden-Ocoee lakefront indexes, log listed properties, suburban listings, and waterfront lists of marked properties for these can be mapped.
Design, invent, and come upon vacation rental in Captiva United States, for rent by owner homes Captiva United States, and Captiva United States homes for rent.
|
|
