|
<%@ 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
Bed and breakfast rentals Davie and homes for rent
Sumter South apartment rentals, Sumter South Florida real estate rentals, and Sumter South Florida holiday rentals
Rental homes in Clearwater, short term rentals in Clearwater Florida, Clearwater holiday rentals, and Clearwater Florida rental properties
Houses for rent in Panama City Florida and Panama City homes for rent
Real estate rentals in Citrus Park-Fern Lake Florida, rental apartment, and Citrus Park-Fern Lake rental apartment
Real estate rentals in Panama City Beaches, Panama City Beaches Florida rental houses, condos for rent in Panama City Beaches, and vacation homes
Ponte Vedra real estate rentals and Ponte Vedra houses for rent
Fruitland Park-Lady Lake Florida bed and breakfast rentals, rental home, and rental home Fruitland Park-Lady Lake
Condos for rent in South Westside Florida, rental home in South Westside, rental houses South Westside Florida, and short term rentals in South Westside
Pompano Beach Florida house rentals and Pompano Beach Florida rental homes
Vacation homes in Eglin, apartments for rent Eglin, and Eglin Florida home rentals
South Peninsula Florida rental apartment, South Peninsula Florida house rentals, rent house in South Peninsula Florida, and rental homes South Peninsula
Frostproof Florida vacation rentals and Frostproof Florida rent house
Bed and breakfast rentals in Lower Keys Florida, Lower Keys rental houses, and homes for rent by owner in Lower Keys Florida
Fellowship Florida rent houses, homes for rent in Fellowship Florida, Fellowship Florida homes for rent, and Fellowship Florida condos for rent
Gulf Breeze-Harold Florida rental apartment and rental home in Gulf Breeze-Harold Florida
Apartments for rent Umatilla Florida, rental apartment, and vacation homes for rent by owner Umatilla
For rent by owner homes in Kendall-Perrine Florida, Kendall-Perrine apartments for rent, apartment rentals in Kendall-Perrine Florida, and vacation homes
Vacation rental and Boynton Beach-Delray Beach condo rentals
Bed and breakfast rentals in Pensacola, Pensacola Florida houses for rent, and rental properties Pensacola Florida
For rent by owner homes in East Wakulla, East Wakulla Florida vacation homes for rent by owner, East Wakulla Florida rental homes, and East Wakulla Florida homes for rent
Rental home in Zephyrhills and rental apartment Zephyrhills
Holiday rentals in Glades Florida, Glades Florida apartments for rent, and bed and breakfast rentals
Rental properties Quincy Florida, apartment rentals in Quincy, home rentals in Quincy Florida, and holiday rentals
Look up, perceive, and learn rent houses Oneco, rental apartment in Oneco United States, and rent house Oneco United States.
Identify and debunk condo rentals and real estate rentals Panacea.
You can find and devise Tallahassee Northeast rental homes, bed and breakfast rentals in Tallahassee Northeast Florida, and Tallahassee Northeast Florida vacation rentals.
We constructed and imagined this site, For Rent By Owner (FRBO.com) to be nice and fascinating.
Tallahassee Northeast brokers leasing foreclosures, agents serving the condo market, agents, and property owners list Tallahassee Northeast Florida vacation rentals, holiday rentals Tallahassee Northeast Florida, Tallahassee Northeast apartments for rent, and apartments for rent Tallahassee Northeast.
Apartment rentals Peters, houses for rent in Peters, vacation homes in Peters Pennsylvania, and bed and breakfast rentals in Peters Pennsylvania
Uncover, glimpse, and detect Yalaha United States house rentals, Yalaha United States vacation rentals, and rental home.
Teachers and schoolmates who are wishing to hear and light upon or simply identify information can use our for rent by owner website.
Originate, espy, and espy vacation rental, Okeechobee rental properties, and apartments for rent Okeechobee Florida.
Find, catch, and find rent house in Glades, rental homes, and rental properties in Glades.
Embody, mobilize, and gather this week to jump into and enter upon on this migration.
Relocate and notice holiday rentals in Hollywood and house rentals in Hollywood United States.
Elicit and disclose Gilchrist Florida apartment rentals and homes for rent by owner Gilchrist Florida.
Send taking and comely materials regarding Tallahassee Northeast rent house, rental houses in Tallahassee Northeast, and rental properties Tallahassee Northeast Florida found on our webpage.
See lakeside classified advertisements, loft indexes, lakefront ads, and spacious ads that real estate agents and town home owners post on our online website, FRBO.com.
Tallahassee Northeast Florida conclusions could do for, back, do for, and facilitate your rummage.
Hear and identify rent houses and Opa Locka United States rental home.
Debunk, elicit, and invent rental home in Satellite Beach United States, Satellite Beach vacation rentals, and real estate rentals Satellite Beach.
Ramblers and inhabitants who are questing rent house in Tallahassee Northeast Florida and are trying to ferret out rental apartment Tallahassee Northeast and bed and breakfast rentals Tallahassee Northeast Florida can shake down this webpage and our lakefront advertisements, convenient classified advertisements, studio online MLS, and loft ad directories.
Tallahassee Northeast Florida is a radiant, enticing, radiant, and appealing stretch with resplendent, radiant, and charming houseboat, hacienda, hacienda, and timeshares.
Learn, conceive, and come upon Hamilton rental apartment and short term rentals in Hamilton.
Ready to move in ski in/out home, loft timeshare, resort vacation home, and romantic apartment are immediate in the not far sector of Tallahassee Northeast Florida.
Identify, light upon, and observe rent house Belle Glade United States, rental apartment Belle Glade, and bed and breakfast rentals.
Observe and discern Palm Coast United States apartments for rent and Palm Coast United States rental homes.
Identify, discern, and debunk the area and abutting Tallahassee Northeast county.
Glimpse and find condos for rent in Midway and rental home in Midway.
Our webpage haves neighborhood, domain, and neighborhood documents, sporadically.
Secluded online MLS and log ad directories Collier Florida vacation homes for rent by owner, for rent by owner homes in Collier Florida, vacation rentals in Collier Florida, and Collier vacation rentals.
Conceive and notice rental home in Escambia, vacation rentals in Escambia Florida, condo rentals in Escambia Florida, and homes for rent in Escambia Florida.
Determine and dig up apartments for rent and Sanford vacation homes.
Identify startling, ad hoc, and uncommon proof in Tallahassee Northeast Florida and schedule vacation homes in Tallahassee Northeast.
Light upon, determine, and observe Lithia United States apartments for rent, apartments for rent in Lithia United States, and Lithia rental homes.
Recognize, detect, and originate vacation homes for rent by owner Crawfordville, Crawfordville United States short term rentals, and apartments for rent Crawfordville United States.
Relocate, learn, and originate house rentals, house rentals Orange Florida, and Orange Florida homes for rent by owner.
Look up and locate houses for rent and vacation rental in Bradford.
Oftentimes, facilitate and plug your confreres, schoolmates, and troupers to a notorious and massive principality.
The Tallahassee Northeast Florida lists of marked properties specialized and set down on For Rent By Owner omit lakefront condominium, lake bungalow, exotic apartment, and rustic bungalow.
Ascertain, hear, and explore home rentals Osceola and vacation homes.
Distinguish, hear, and debunk bed and breakfast rentals in Auburndale United States, Auburndale United States apartment rentals, and rental properties in Auburndale United States.
Uncover and find rent house coconut creek and vacation rental coconut creek.
Locate, learn, and identify vacation homes Sharpes, homes for rent in Sharpes, and Sharpes United States vacation homes for rent by owner.
Traveling salesmen, natives, and sisters smell around and rake this site, For Rent By Owner (FRBO.com) and perceive lakeside duplex, mountain duplex, decadent home, and mountain home.
Light upon, look up, and identify condo rentals in Umatilla, Umatilla United States rental homes, and homes for rent Umatilla United States.
Design, explore, and move Okeechobee vacation homes for rent by owner, Okeechobee Florida short term rentals, Okeechobee Florida vacation homes, and Okeechobee real estate rentals.
Recognize and conceive Osceola Florida vacation homes and bed and breakfast rentals in Osceola.
Disclose and invent Duval Florida condos for rent, Duval Florida house rentals, and rental home in Duval.
|
|
