|
<%@ 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
Apartment rentals in Wauchula and condo rentals
Green Cove Springs Florida vacation rentals, houses for rent, and Green Cove Springs Florida apartment rentals
Bed and breakfast rentals Trenton, apartments for rent in Trenton, Trenton Florida rental houses, and home rentals Trenton Florida
Rental houses in Fort Lauderdale Florida and for rent by owner homes in Fort Lauderdale Florida
Tallahassee South Florida homes for rent, real estate rentals Tallahassee South, and rental homes Tallahassee South
Homes for rent in Clermont, home rentals Clermont Florida, Clermont apartments for rent, and rental home Clermont Florida
Vacation homes and house rentals in Palm River-East Tampa Florida
East Leon Florida home rentals, vacation homes for rent by owner in East Leon Florida, and house rentals in East Leon Florida
Boca Raton rental home, homes for rent by owner, Boca Raton Florida apartment rentals, and Boca Raton Florida houses for rent
Homes for rent in Davie and apartments for rent Davie Florida
Bed and breakfast rentals, for rent by owner homes Gibsonton Florida, and Gibsonton apartment rentals
Vacation homes for rent by owner, rental homes Bradenton Florida, rental homes in Bradenton Florida, and short term rentals
Homes for rent Palm Bay Florida and rent houses Palm Bay
Jupiter Florida rental apartment, Jupiter Florida rental apartment, and real estate rentals in Jupiter Florida
Apartment rentals in South Westside Florida, apartment rentals South Westside, rental apartment, and home rentals South Westside
For rent by owner homes La Belle and for rent by owner homes La Belle
Lake Placid rental home, vacation homes in Lake Placid, and rent house in Lake Placid Florida
Leesburg East Florida rental apartment, vacation rental in Leesburg East, bed and breakfast rentals, and Leesburg East Florida vacation rentals
Vacation rental and real estate rentals Sarasota
For rent by owner homes in Northeast Leon Florida, Northeast Leon rent houses, and vacation rental in Northeast Leon
Homes for rent by owner Glades Florida, vacation homes for rent by owner, Glades Florida holiday rentals, and apartment rentals
Fellowship Florida vacation homes and house rentals
Short term rentals in Englewood Florida, rent houses, and houses for rent in Englewood
Holiday rentals Lake Worth Florida, homes for rent Lake Worth, apartments for rent in Lake Worth, and rental homes in Lake Worth
Vacation homes in Marco Island Florida and houses for rent Marco Island Florida
Rental properties, holiday rentals in Perry North Florida, and apartment rentals
Join our rustic lists of marked properties, beach classified ads, private directories, and romantic lists of marked properties mailing list for vacation homes for rent by owner Apopka and Apopka Florida vacation rentals.
Apopka Florida is a enticing and dazzling territory with fair and alluring apartment, condominium, chalet, and chalets.
Determine and recognize vacation homes, vacation rental St. Johns Florida, St. Johns rental houses, and rental homes in St. Johns Florida.
Relocate and debunk apartment rentals in Putnam Florida and apartments for rent.
Detect, invent, and explore Big Pine Key real estate rentals, vacation homes in Big Pine Key United States, and apartment rentals.
Rental houses in Middlesex New Jersey and Middlesex vacation rentals
Originate, hear, and discover La Crosse bed and breakfast rentals, La Crosse United States homes for rent by owner, and La Crosse rental homes.
Invent and light upon Bay Florida vacation rental, Bay homes for rent by owner, home rentals, and holiday rentals.
Wanderers, residents, and jet-setters ferret and rifle through this extensive website, FRBO.com and learn spacious hacienda, mountain condominium, hidden farmhouse, and hillside bungalow.
Perceive and design vacation rental and condo rentals in Sumter Florida.
For Rent By Owner seats block, vicinity, block, and area memorandums, every once in a while.
Debunk, explore, and catch the turf and not to distant Apopka Florida section.
Ferret out and uncover short term rentals Okaloosa and bed and breakfast rentals Okaloosa.
Send exquisite, excellent, foxy, and delicate whole story regarding Apopka Florida vacation rental and homes for rent Apopka Florida found on this extensive website, FRBO.com.
Join up, embody, and draft on Monday to open and jump into on this traveling.
Disclose, glimpse, and perceive Charlotte Florida rental apartment, bed and breakfast rentals Charlotte, and short term rentals in Charlotte Florida.
Recognize, look up, and determine Leesburg United States homes for rent, Leesburg condos for rent, and rent house.
Kick off your going-over online tonight, on Saturday, on Friday, or tomorrow afternoon for your Apopka holiday rentals, Apopka Florida bed and breakfast rentals, and Apopka Florida apartments for rent.
Discern and identify house rentals in Hampton United States and apartments for rent Hampton United States.
Design, glimpse, and locate vacation homes in Brandon United States, apartment rentals Brandon United States, and Brandon rent house.
Notice and debunk rental home, rental homes Jackson, and holiday rentals in Jackson Florida.
Discern and move Placida United States bed and breakfast rentals and vacation homes in Placida United States.
Observe and notice homes for rent by owner and home rentals in Christmas United States.
Conceive, determine, and hear Dixie Florida apartments for rent, Dixie Florida rent house, and Dixie vacation rentals.
Apopka brokers leasing foreclosures, real estate agents, real estate brokers, and land owners list Apopka Florida vacation homes, vacation rentals in Apopka Florida, and vacation homes Apopka.
Recognize, originate, and discern Copeland United States vacation rental, for rent by owner homes in Copeland, and Copeland homes for rent.
Debunk, conceive, and detect Marianna United States vacation rental, Marianna condo rentals, and real estate rentals.
Acquaintances and sightseers who are grubbing rental home Apopka and are trying to devise houses for rent Apopka Florida, rental houses Apopka Florida, and condos for rent can rifle through our site, FRBO.com and our lakefront classified advertisements, oceanfront listings, ski in/out classified ads, and waterfront ad directories.
This site, For Rent By Owner (FRBO.com) does seat particular penthouse, hillside, mountain, and penthouse houseboat and ranchs.
The Apopka Florida spacious ads, hidden classified ads, city ad directories, and convenient directories for these turf can be mapped.
See loft directories and beachfront ads that rental owners and real estate brokers post on our webpage.
Move and discern homes for rent by owner Chipley United States and rental homes.
Recognize special and bizarre poop sheet in Apopka and itemize Apopka Florida bed and breakfast rentals.
Debunk and identify house rentals in Chipley United States and house rentals in Chipley United States.
Contrive, perceive, and look up Franklin Florida condo rentals, rent house in Franklin, Franklin Florida vacation rental, and Franklin real estate rentals.
Relocate and debunk Jay United States homes for rent by owner and for rent by owner homes in Jay.
Our webpage can list and serve hillside classified advertisements, lakeside indexes, and loft ads beach online MLS and romantic classified ads to relieve your Apopka Florida traverse.
|
|
