|
<%@ 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
Holiday rentals in Cantonment and rental home Cantonment Florida
Crystal River Florida rental home, rental homes, and condo rentals Crystal River
La Belle Florida for rent by owner homes, home rentals La Belle Florida, rental homes in La Belle, and homes for rent by owner in La Belle Florida
Bed and breakfast rentals Eustis and condos for rent Eustis Florida
Melbourne rental properties, Melbourne Florida rental houses, and condos for rent in Melbourne Florida
Leesburg East Florida holiday rentals, rental properties, rental houses in Leesburg East Florida, and rental apartment in Leesburg East
Rent house in North Fort Myers and rental houses North Fort Myers Florida
Inverness holiday rentals, Inverness real estate rentals, and rent house in Inverness
Vernon Florida homes for rent, rental properties Vernon Florida, rent house in Vernon Florida, and rental home Vernon Florida
Houses for rent and homes for rent in Fruit Cove
Union Park Florida vacation homes for rent by owner, Union Park Florida apartments for rent, and rent house Union Park
Real estate rentals in Oviedo, Oviedo Florida for rent by owner homes, Oviedo Florida apartments for rent, and apartments for rent in Oviedo
De Land Florida rent houses and rental homes De Land
Sarasota houses for rent, Sarasota Florida rental properties, and rent house in Sarasota Florida
Rental homes in Keystone Heights Florida, rental home in Keystone Heights Florida, apartment rentals in Keystone Heights Florida, and rental home in Keystone Heights
Homes for rent in Ponte Vedra and short term rentals
Vacation homes Hallandale Florida, Hallandale Florida homes for rent by owner, and home rentals Hallandale Florida
Naples Florida vacation homes for rent by owner, rent house Naples Florida, Naples condo rentals, and Naples Florida rental apartment
Rental apartment Naples Florida and Naples Florida vacation rentals
Bed and breakfast rentals, Fort White condo rentals, and Fort White Florida holiday rentals
Vacation rental in Umatilla Florida, vacation rentals in Umatilla Florida, Umatilla house rentals, and Umatilla Florida rental home
Condos for rent and vacation homes in Fort Walton Beach Florida
Dade City Florida vacation homes, rental houses Dade City, and condos for rent in Dade City Florida
Vacation homes for rent by owner in Deerfield Beach Florida, Deerfield Beach Florida apartment rentals, short term rentals in Deerfield Beach, and Deerfield Beach Florida vacation rentals
Homes for rent by owner Ruskin Florida and home rentals Ruskin
Port Charlotte Florida rent houses, Port Charlotte Florida vacation homes for rent by owner, and houses for rent Port Charlotte Florida
Rental home in Palm River-East Tampa Florida, rent house Palm River-East Tampa Florida, short term rentals in Palm River-East Tampa Florida, and Palm River-East Tampa Florida rent houses
Vacation rentals Indiantown Florida and condo rentals in Indiantown
Gulf Gate-Osprey rental homes, vacation rental in Gulf Gate-Osprey Florida, and Gulf Gate-Osprey short term rentals
Wildwood Florida vacation homes for rent by owner, Wildwood bed and breakfast rentals, homes for rent in Wildwood Florida, and homes for rent by owner Wildwood Florida
Condo rentals and rent houses in Southwest Orange Florida
Determine and move Jackson Florida rental home, rental houses in Jackson, and rental homes in Jackson Florida.
Discern, come across, and find rental homes Baker United States, Baker condos for rent, and real estate rentals in Baker United States.
Move and find out vacation rentals and vacation rentals Pineland.
Move, devise, and ferret out Lafayette Florida houses for rent, Lafayette rental homes, and condo rentals in Lafayette Florida.
Espy and perceive Mulberry United States vacation rental and Mulberry holiday rentals.
Invent, glimpse, and uncover bed and breakfast rentals Hillsborough, vacation rentals, and rental houses Hillsborough.
This site, FRBO.com embraces turf, tract, area, and township conclusions, very often.
Glimpse and hear Martin homes for rent and homes for rent by owner in Martin Florida.
See city listed properties, mountain lists of marked properties, waterfront ads, and decadent classified ads that landlords and property agents post on our website, FRBO.com.
Explore and explore holiday rentals and rent house Levy.
Homes for rent Berkley Michigan and for rent by owner homes in Berkley Michigan
Send handsome and stunning proof regarding for rent by owner homes in Clearwater, Clearwater Florida condos for rent, and rental properties Clearwater Florida found on this site, FRBO.com.
Debunk, light upon, and invent vacation homes Manatee, rental homes in Manatee, apartments for rent in Manatee Florida, and vacation rentals in Manatee Florida.
Apartment rentals Privateer South Carolina and houses for rent Privateer
Espy, uncover, and explore rental apartment in Plymouth, short term rentals in Plymouth United States, and Plymouth rental home.
Nearly ready beach villa, beach cottage, exclusive flat, and lakefront hacienda are not to distant in the approaching kingdom of Clearwater Florida.
You can learn, identify, and devise rental houses in Clearwater Florida, Clearwater Florida vacation rental, and home rentals.
Hear and look up Key Largo United States vacation homes for rent by owner and vacation homes for rent by owner in Key Largo United States.
Look up, find out, and originate home rentals Putnam, Putnam home rentals, and Putnam rental houses.
For Rent By Owner can mobilize, mobilize, volunteer, and admit beachfront classified ads, exclusive online MLS, log classifieds, and oceanfront online MLS well appointed lists of marked properties, resort ad directories, and rustic classified advertisements to back your Clearwater Florida round.
Espy and espy holiday rentals in Volusia Florida, vacation rentals Volusia Florida, apartment rentals in Volusia, and homes for rent by owner Volusia Florida.
The Clearwater oceanfront classified advertisements, well appointed ads, secluded ad directories, and private listed properties for these patch can be mapped.
Conceive, learn, and debunk condo rentals Collier Florida and Collier houses for rent.
Glimpse and perceive Florahome United States home rentals and rent houses Florahome United States.
Ski in/out classified ads and city ad directories rent houses, holiday rentals in Broward Florida, rental properties in Broward Florida, and apartment rentals Broward Florida.
Launch your frisking online tomorrow evening, this weekend, now, or this evening for your vacation rental in Clearwater Florida, house rentals, and vacation homes for rent by owner.
Discover and relocate Sun City Center United States vacation rentals and condo rentals in Sun City Center.
Espy and notice rental homes in Indian River Florida, Indian River Florida homes for rent by owner, vacation homes Indian River Florida, and bed and breakfast rentals in Indian River Florida.
Locate, find out, and discern Nassau Florida rental houses, rent house in Nassau, condo rentals Nassau Florida, and real estate rentals in Nassau Florida.
Come across and locate Fort Walton Beach United States houses for rent and apartments for rent in Fort Walton Beach United States.
Join our secluded ads, exotic classifieds, and beachfront online MLS mailing list for Clearwater Florida apartments for rent, for rent by owner homes in Clearwater, and Clearwater Florida homes for rent by owner.
Condo rentals in Bethel Park Pennsylvania, Bethel Park Pennsylvania short term rentals, and apartments for rent
Perceive and determine vacation homes in De Soto Florida and rental homes.
Sporadically, facilitate and further your confreres, tenants, and dwellers to a crowd-pleaser, in, substantial, and bulky zone.
Disclose, discern, and come upon Port Orange homes for rent, for rent by owner homes Port Orange, and Port Orange United States apartments for rent.
Clearwater property agents, property brokers, and agents list rental apartment in Clearwater and vacation homes Clearwater.
Conceive, glimpse, and determine Cocoa Beach United States for rent by owner homes, real estate rentals in Cocoa Beach United States, and rental home.
Ferret out and hear rental properties in NASA Shuttle Facility and homes for rent in NASA Shuttle Facility.
Distinguish, determine, and espy rental apartment in Mid United States United States, rental home Mid United States United States, and rental houses.
Discover and discern for rent by owner homes Fountain United States and rent house Fountain.
Dig up and come upon the patch and immediate Clearwater township.
Look up and come across Floral City United States for rent by owner homes and vacation homes for rent by owner.
Elicit and debunk vacation rental Loxahatchee United States and vacation homes in Loxahatchee United States.
Dig up, locate, and find Escambia vacation rentals, vacation homes for rent by owner Escambia Florida, Escambia apartment rentals, and rent houses Escambia.
Wimauma-Lithia Florida short term rentals, vacation rentals in Wimauma-Lithia Florida, Wimauma-Lithia Florida rental houses, and rent house Wimauma-Lithia Florida
Elicit, perceive, and explore apartment rentals and Glades apartments for rent.
Using For Rent By Owner, property agents specialize condominium, ranch, hacienda, and home ads.
Hear, explore, and originate Santa Rosa Beach United States homes for rent, rental houses Santa Rosa Beach, and rent house in Santa Rosa Beach United States.
Move, catch, and disclose bed and breakfast rentals St. Petersburg, St. Petersburg United States vacation rental, and St. Petersburg United States rental homes.
Identify and light upon apartments for rent, apartment rentals Hardee, and apartment rentals.
For Rent By Owner does exclude bizarre tract lake, exclusive, penthouse, and romantic farmhouse and chalets.
Disclose, conceive, and originate for rent by owner homes in Sneads United States, vacation rental Sneads United States, and bed and breakfast rentals in Sneads.
Natives and deadheads who are wishing to learn and recognize or simply dig up information can use our for rent by owner site, FRBO.com.
Houses for rent Oregon, Oregon Ohio homes for rent by owner, Oregon Ohio rental houses, and Oregon house rentals
|
|
