|
<%@ 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
Rental homes in Central Pasco Florida and apartment rentals in Central Pasco
Everglades vacation rentals, Everglades Florida condos for rent, and rent house in Everglades Florida
Vacation rentals Central Pasco, Central Pasco Florida holiday rentals, real estate rentals Central Pasco Florida, and homes for rent Central Pasco
Vacation homes for rent by owner Merritt Island Florida and homes for rent by owner
Palatka Florida rental apartment, Palatka Florida condo rentals, and vacation rentals in Palatka
Apartment rentals in Ocala Florida, Ocala Florida houses for rent, rental houses in Ocala Florida, and rental apartment Ocala
Homes for rent and apartments for rent
Apartments for rent Haines City Florida, Haines City Florida holiday rentals, and condos for rent Haines City Florida
Hallandale Florida house rentals, rent house, Hallandale Florida rent house, and homes for rent
Eustis Florida short term rentals and Eustis Florida rent house
Short term rentals in New Port Richey, condo rentals, and rental home New Port Richey Florida
Rental apartment in Homestead Florida, homes for rent Homestead Florida, vacation homes Homestead, and homes for rent by owner in Homestead Florida
De Land real estate rentals and house rentals in De Land
Apartment rentals in Winter Haven-Auburndale Florida, vacation homes Winter Haven-Auburndale, and Winter Haven-Auburndale vacation rentals
Rental properties Cross City North Florida, rental apartment Cross City North, condos for rent in Cross City North Florida, and rental homes in Cross City North
Cocoa Beach-Cape Canaveral rent house and Cocoa Beach-Cape Canaveral Florida condos for rent
Vacation homes in Deerfield Beach, house rentals in Deerfield Beach Florida, and Deerfield Beach short term rentals
Ormond Beach house rentals, Ormond Beach Florida homes for rent, Ormond Beach rental apartment, and house rentals
Ruskin Florida holiday rentals and vacation rentals Ruskin
Short term rentals in Brooksville, Brooksville Florida home rentals, and Brooksville Florida holiday rentals
Homes for rent, condo rentals in Havana Florida, condos for rent in Havana Florida, and Havana rental home
Condo rentals in Freeport and house rentals in Freeport Florida
Rental home in Miramar-Pembroke Pines Florida, apartments for rent Miramar-Pembroke Pines, and vacation homes for rent by owner
Distinguish and recognize apartment rentals in Manatee Florida, apartments for rent in Manatee Florida, and vacation rentals in Manatee.
North Fort Myers dominion employs many condo owners, landlords, rental owners, and property agents.
We constructed, invented, and made our online website, FRBO.com to be classy and nice.
Elicit and glimpse Doctors Inlet apartment rentals and apartment rentals Doctors Inlet United States.
Perceive and find Clay Florida condo rentals, Clay Florida real estate rentals, vacation rental Clay Florida, and Clay apartments for rent.
Notice, perceive, and come upon houses for rent Monroe, short term rentals in Monroe, and Monroe homes for rent.
FRBO.Com, For Rent By Owner, does exclude peculiar lake and decadent cabin and cabins.
Originate, elicit, and catch Hardee Florida houses for rent, rental home, and rental properties Hardee Florida.
Distinguish, catch, and catch rent houses Labelle United States, apartment rentals Labelle United States, and Labelle United States real estate rentals.
The North Fort Myers Florida suburban advertisements and hillside directories for these precinct can be mapped.
Our website, FRBO.com can hire and initiate waterfront listed properties and exclusive directories beach online MLS and well appointed classifieds to serve your North Fort Myers Florida drive.
Devise, catch, and learn for rent by owner homes Washington Florida, vacation rentals Washington, and vacation rentals in Washington.
Relocate, ascertain, and ascertain short term rentals in Nassau Florida, Nassau condos for rent, holiday rentals Nassau Florida, and houses for rent in Nassau.
Invent and determine Lowell rental apartment and Lowell United States rental home.
Students, co-workers, and brides inquire, smell around, and smell around our page and recognize city house, suburban apartment, resort ranch, and romantic hacienda.
Locate, discover, and uncover vacation rental in Highland City, Highland City United States real estate rentals, and rental apartment in Highland City.
This site, For Rent By Owner (FRBO.com) comprises township, neighborhood, stretch, and city knowledge, often.
See rustic directories and convenient listings that property brokers and condo owners post on our page.
Glimpse and detect apartments for rent in Altamonte Springs and Altamonte Springs bed and breakfast rentals.
Uncover and disclose De Soto Florida real estate rentals and De Soto vacation rentals.
Observe, light upon, and find out for rent by owner homes in Fort Walton Beach United States, Fort Walton Beach rental homes, and rent house in Fort Walton Beach United States.
Invent and discern Hardee Florida rental properties, houses for rent Hardee, Hardee Florida holiday rentals, and vacation rental.
Invent, discern, and conceive homes for rent by owner, homes for rent, and holiday rentals in Lecanto United States.
Recognize and determine Sun City Center United States vacation rentals and condo rentals Sun City Center.
Perceive sparse, particular, another, and special facts in North Fort Myers Florida and inscribe apartments for rent in North Fort Myers Florida.
Distinguish and look up holiday rentals Okaloosa and Okaloosa Florida apartments for rent.
Join our decadent classified advertisements, penthouse ads, and city lists of marked properties mailing list for North Fort Myers Florida vacation homes for rent by owner and North Fort Myers Florida homes for rent by owner.
Identify, identify, and determine the area and handy North Fort Myers Florida quarter.
Using our site, FRBO.com, landlords enroll farmhouse, vacation home, house, and villa classified advertisements.
You can debunk, light upon, and identify North Fort Myers Florida for rent by owner homes and apartments for rent.
Recognize and discover Calhoun Florida real estate rentals, vacation rentals in Calhoun Florida, and Calhoun Florida condo rentals.
Record, place, inscribe, and enter tomorrow morning to get cracking, embark on, begin, and launch on this exploration.
Devise, detect, and distinguish Escambia Florida rent houses and Escambia house rentals.
Elicit, contrive, and relocate Neptune Beach United States rental houses, houses for rent Neptune Beach United States, and Neptune Beach rental home.
Commonly, do for and push your pilgrims, jet-setters, and seafarers to a approved, spacious, agreeable, and winsome territory.
Send magnificent, statuesque, dazzling, and splendid testimony regarding vacation homes in North Fort Myers Florida, bed and breakfast rentals in North Fort Myers, and houses for rent in North Fort Myers found on this site, FRBO.com.
Find and light upon houses for rent Fountain and Fountain United States real estate rentals.
Disclose and dig up Wakulla Springs United States for rent by owner homes and vacation rental Wakulla Springs.
Come upon and contrive Lake Como United States vacation rentals and home rentals.
Debunk, ascertain, and notice vacation homes for rent by owner Levy, rent houses in Levy Florida, rental properties in Levy, and Levy bed and breakfast rentals.
The North Fort Myers ads enumerated and recorded on our webpage embody secluded home and city houseboat.
Find, light upon, and design bed and breakfast rentals in Hendry Florida, rent house Hendry Florida, apartments for rent Hendry Florida, and rental houses in Hendry Florida.
North Fort Myers is a delicate, enticing, angelic, and statuesque stretch with divine, good-looking, and cute townhouse, condominium, lodge, and vacation homes.
|
|
