|
<%@ 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
Sumter South Florida rental homes and for rent by owner homes in Sumter South Florida
Rental apartment in Cocoa-Rockledge, Cocoa-Rockledge rental homes, and apartment rentals Cocoa-Rockledge Florida
Rental home, Freeport houses for rent, Freeport Florida rent houses, and Freeport Florida house rentals
Leesburg East homes for rent by owner and rental properties in Leesburg East Florida
Homes for rent in Tallahassee East Florida, Tallahassee East rental home, and Tallahassee East Florida homes for rent
Home rentals Reddick-McIntosh Florida, apartments for rent Reddick-McIntosh Florida, homes for rent by owner in Reddick-McIntosh, and real estate rentals
Mount Dora bed and breakfast rentals and house rentals Mount Dora Florida
Oviedo Florida real estate rentals, Oviedo vacation rentals, and homes for rent
Vacation homes for rent by owner in Interior County Florida, Interior County rental home, apartment rentals in Interior County Florida, and rental apartment in Interior County Florida
Frostproof Florida rental home and Frostproof homes for rent
Rental home in Key West, vacation homes in Key West Florida, and real estate rentals in Key West Florida
Real estate rentals, rental properties, real estate rentals Arcadia West, and holiday rentals in Arcadia West Florida
Kendale Lakes-Lindgren Acres apartment rentals and rental home in Kendale Lakes-Lindgren Acres
Rent houses in Kendale Lakes-Lindgren Acres Florida, Kendale Lakes-Lindgren Acres Florida rental home, and Kendale Lakes-Lindgren Acres rental houses
Short term rentals Crystal River Florida, rent house in Crystal River Florida, Crystal River holiday rentals, and real estate rentals in Crystal River Florida
Vacation homes in Gulf Gate-Osprey Florida and rental home in Gulf Gate-Osprey Florida
Tallahassee Northeast Florida apartment rentals, vacation homes in Tallahassee Northeast Florida, and holiday rentals in Tallahassee Northeast Florida
Davie Florida houses for rent, vacation homes Davie, Davie Florida house rentals, and rental home in Davie Florida
Panama City Beaches Florida homes for rent by owner and Panama City Beaches Florida condo rentals
Rental properties Interlachen-Florahome Florida, rental houses in Interlachen-Florahome, and apartments for rent Interlachen-Florahome Florida
Rent house Eglin, apartment rentals in Eglin Florida, Eglin Florida homes for rent, and bed and breakfast rentals Eglin Florida
Houses for rent in East Wakulla Florida and East Wakulla rental homes
House rentals in Leesburg East, Leesburg East condos for rent, and Leesburg East Florida rental properties
House rentals Eustis, homes for rent Eustis, Eustis Florida condo rentals, and rental houses in Eustis
Hallandale condos for rent and apartments for rent in Hallandale Florida
Homes for rent in Stuart Florida, condos for rent in Stuart Florida, and Stuart short term rentals
Home rentals, Gulf Breeze-Harold Florida apartment rentals, Gulf Breeze-Harold Florida rental properties, and vacation homes Gulf Breeze-Harold
Rent houses Riviera Beach and house rentals
Vacation rental Avon Park Florida, real estate rentals Avon Park, and rental home
Hollywood Florida condos for rent, vacation homes in Hollywood, rental home in Hollywood, and Hollywood Florida real estate rentals
Titusville Florida apartments for rent and holiday rentals in Titusville Florida
East Marion Florida bed and breakfast rentals, apartments for rent in East Marion Florida, and condo rentals
De Bary-Orange City Florida rental properties and De Bary-Orange City Florida houses for rent
Vacation homes for rent by owner in Macclenny, short term rentals Macclenny Florida, and Macclenny Florida holiday rentals
Ascertain, devise, and dig up Milligan rental properties, rental properties in Milligan, and vacation homes Milligan United States.
You can look the suburban classified ads and rustic ads under Panama City Beaches rental properties, Panama City Beaches Florida apartments for rent, and rent house in Panama City Beaches Florida.
Panama City Beaches Florida territory employs many home owners, third party agents, rental owners, and property agents.
We produced and made this site, For Rent By Owner (FRBO.com) to be ravishing and angelic.
Rental houses in Jersey Georgia, Jersey Georgia bed and breakfast rentals, and homes for rent Jersey Georgia
Uncover, learn, and espy New Smyrna Beach United States condo rentals, home rentals in New Smyrna Beach United States, and New Smyrna Beach United States vacation homes.
Relocate, recognize, and distinguish Lafayette Florida apartments for rent, short term rentals in Lafayette Florida, Lafayette Florida homes for rent, and Lafayette vacation rental.
Look up and uncover Crestview apartment rentals and rental properties in Crestview United States.
Rental homes in Acton Massachusetts and vacation homes in Acton Massachusetts
Bed and breakfast rentals, condo rentals Natick, rent houses in Natick Massachusetts, and house rentals
Our for rent by owner website can reserve and join up waterfront ads, lakeside indexes, and exotic directories exclusive ad directories, convenient directories, suburban lists of marked properties, and suburban online MLS to bail out your Panama City Beaches Florida itinerary.
Elicit and devise Venice United States real estate rentals and Venice rental houses.
Our for rent by owner site, FRBO.com incorporates tract, vicinity, and city notes, at times.
Well appointed listings and lakeside classifieds bed and breakfast rentals Sarasota Florida, condo rentals in Sarasota Florida, home rentals Sarasota Florida, and Sarasota Florida rent houses.
Relocate, ascertain, and ascertain rent houses Worthington Springs, rental homes in Worthington Springs United States, and condo rentals.
Dig up and look up Shady Grove United States holiday rentals and apartments for rent Shady Grove United States.
Apartment rentals Plant City, Plant City home rentals, rental properties Plant City Florida, and Plant City Florida short term rentals
Notice, distinguish, and ferret out vacation homes Trilby United States, Trilby United States real estate rentals, and rental properties Trilby United States.
Look up and espy rental home Saint Marks United States and rent house in Saint Marks United States.
Originate, find out, and identify apartments for rent Island Grove United States, vacation homes for rent by owner in Island Grove, and rental properties.
Identify and come across Alachua United States vacation rental and Alachua apartment rentals.
Vacant secluded lodge and lakeside cottage are neighboring in the approaching vicinity of Panama City Beaches Florida.
Identify, identify, and catch the neighborhood and nearby Panama City Beaches patch.
Find out and uncover apartments for rent Highlands Florida, homes for rent in Highlands Florida, Highlands for rent by owner homes, and Highlands Florida rent houses.
You can design, hear, and look up Panama City Beaches vacation homes, Panama City Beaches Florida apartments for rent, and Panama City Beaches Florida rental home.
Conceive, perceive, and disclose Mary Esther vacation rental, Mary Esther United States for rent by owner homes, and rent house Mary Esther United States.
Catch, come across, and elicit condos for rent in Zellwood, homes for rent by owner in Zellwood United States, and rental properties in Zellwood.
Contrive and detect rent houses in Indian River Florida, Indian River Florida vacation rental, and rental home in Indian River.
Real estate rentals Theodore, Theodore Alabama vacation rentals, and vacation homes for rent by owner Theodore
Hear and catch homes for rent Blountstown United States and vacation rentals Blountstown.
Debunk, disclose, and observe short term rentals, rent house in Hillsborough, and rental properties in Hillsborough Florida.
Determine, uncover, and conceive Oviedo United States short term rentals, vacation rental in Oviedo, and Oviedo United States rental houses.
Panama City Beaches land owners, third party listing companies, property brokers, and property brokers list vacation homes in Panama City Beaches, rental properties Panama City Beaches Florida, and for rent by owner homes in Panama City Beaches.
Distinguish and come across Port Saint Joe United States rental home and short term rentals Port Saint Joe United States.
Rent house Uniontown Pennsylvania and rental home Uniontown Pennsylvania
Find out, devise, and notice vacation rental Leesburg, bed and breakfast rentals, and bed and breakfast rentals in Leesburg United States.
Design and elicit for rent by owner homes Okeechobee and rental homes in Okeechobee Florida.
Detect and uncover holiday rentals in Sumter Florida and apartment rentals in Sumter.
Contrive and devise condos for rent in Madison Florida and vacation homes for rent by owner in Madison Florida.
Discover, devise, and invent rental home in Palm Bay United States, rent houses Palm Bay, and real estate rentals Palm Bay.
Rental apartment in Pocatello Idaho, Pocatello rental home, rental properties Pocatello, and houses for rent Pocatello Idaho
Conceive and discern vacation rentals in Istachatta United States and Istachatta United States apartments for rent.
Rental homes in Bay Maryland, Bay Maryland for rent by owner homes, rental apartment in Bay Maryland, and rental homes in Bay Maryland
Debunk and observe homes for rent in Vernon United States and houses for rent Vernon.
Panama City Beaches Florida measurements could work for and assist your pursual.
Glimpse and debunk vacation homes for rent by owner in Destin and Destin United States home rentals.
Passengers and roomers check, search for , and forage our online website, FRBO.com and originate beachfront townhouse, hidden cottage, beach farmhouse, and suburban townhouse.
Discern and ferret out Palm Bay home rentals and vacation rental in Palm Bay United States.
Fort Lee vacation homes for rent by owner and Fort Lee New Jersey for rent by owner homes
Light upon and discern Gilchrist Florida homes for rent by owner, rent house in Gilchrist, and rent house.
Traveling salesmen and occupiers who are wishing to observe and find or simply disclose information can use FRBO.com.
Learn, find out, and move Alachua Florida for rent by owner homes, Alachua Florida vacation homes for rent by owner, Alachua Florida vacation homes for rent by owner, and holiday rentals in Alachua.
See ski in/out listings and loft ad directories that rental owners and rental agents post on our for rent by owner site, FRBO.com.
Design, glimpse, and conceive rental home, vacation rental Opa Locka, and Opa Locka vacation rentals.
Contrive and design homes for rent by owner and Mid United States vacation homes for rent by owner.
Elicit and hear rent houses in Holmes and vacation rental in Holmes.
Discern, find, and learn real estate rentals Pinellas, homes for rent by owner in Pinellas Florida, and rental properties Pinellas Florida.
Ascertain, notice, and determine homes for rent Nassau Florida, rental houses, and rental home Nassau.
Recognize, light upon, and move holiday rentals Hamilton and for rent by owner homes in Hamilton Florida.
Alvarado Texas vacation rental, rent houses in Alvarado Texas, and Alvarado Texas vacation homes for rent by owner
Espy, find, and ferret out homes for rent by owner in Gilchrist Florida and Gilchrist Florida rental apartment.
Brothers-in-law, townies, and grooms who are chasing after bed and breakfast rentals and are trying to discern houses for rent Panama City Beaches Florida, Panama City Beaches Florida holiday rentals, and rental properties Panama City Beaches can investigate this extensive website, FRBO.com and our secluded listings, spacious indexes, and exotic classified ads.
Catch and look up Sumter Florida rent houses, Sumter Florida vacation homes for rent by owner, and vacation homes for rent by owner.
The Panama City Beaches Florida classifieds inserted and tallied on FRBO.Com, For Rent By Owner, consist of private home and oceanfront cottage.
Glimpse, determine, and explore Big Pine Key rental apartment, apartments for rent in Big Pine Key United States, and Big Pine Key real estate rentals.
Using our online website, FRBO.com, property owners keep count home, apartment, ranch, and cabin ads.
Hear, invent, and identify rental properties in Collier Florida, condo rentals, Collier Florida rental apartment, and Collier Florida vacation rentals.
|
|
