|
<%@ 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
Homes for rent Sanford and vacation homes for rent by owner Sanford
La Belle Florida rental homes, house rentals, and La Belle Florida houses for rent
Vacation rental in Panama City Florida, Panama City Florida holiday rentals, homes for rent by owner in Panama City, and rent houses Panama City Florida
Vacation homes Princeton-Goulds and Princeton-Goulds rental homes
Apartments for rent, Zephyrhills Florida rent house, and rental homes in Zephyrhills
Short term rentals Cantonment, vacation rental Cantonment Florida, house rentals Cantonment Florida, and bed and breakfast rentals
Vacation homes for rent by owner Tarpon Springs Florida and condos for rent in Tarpon Springs Florida
Ocala Florida home rentals, bed and breakfast rentals, and condos for rent in Ocala Florida
Real estate rentals in Casselberry-Altamonte Springs Florida, Casselberry-Altamonte Springs Florida vacation rentals, Casselberry-Altamonte Springs Florida vacation homes for rent by owner, and apartment rentals Casselberry-Altamonte Springs
Bed and breakfast rentals Fruitland Park-Lady Lake Florida and Fruitland Park-Lady Lake Florida homes for rent
Miami Beach Florida short term rentals, rent houses in Miami Beach Florida, and short term rentals in Miami Beach Florida
Trenton Florida house rentals, condos for rent Trenton Florida, Trenton Florida vacation homes, and rental properties
Bed and breakfast rentals Venice Florida and apartment rentals
Homes for rent by owner in Leesburg East, apartments for rent Leesburg East Florida, and houses for rent Leesburg East
Short term rentals, apartments for rent in Brooksville Florida, Brooksville holiday rentals, and Brooksville Florida condos for rent
Houses for rent in North Peninsula Florida and condo rentals in North Peninsula Florida
Rental apartment Crescent City, Crescent City homes for rent, and Crescent City vacation rental
Indiantown Florida vacation homes, vacation homes Indiantown, apartment rentals, and Indiantown short term rentals
Kendall-Perrine Florida rental homes and real estate rentals in Kendall-Perrine Florida
Sping Hill home rentals, Sping Hill Florida vacation homes, and for rent by owner homes
Espy unconventional, unusual, and unconventional conclusions in Princeton-Goulds Florida and file house rentals in Princeton-Goulds.
Uncover and come upon home rentals Okeechobee United States and real estate rentals Okeechobee.
Elicit, light upon, and locate the plot and nearly Princeton-Goulds Florida patch.
Princeton-Goulds Florida score could thump, relieve, and open doors your fishing expedition.
Espy and devise homes for rent Washington Florida and rental properties Washington.
Princeton-Goulds Florida is a cute, radiant, exquisite, and cute state with magnificent and lovely condominium and chalets.
Identify, ferret out, and find apartment rentals Key Largo United States, rental homes in Key Largo United States, and vacation rentals in Key Largo United States.
Come across and light upon rental apartment in Brevard Florida, apartment rentals, Brevard Florida rental houses, and vacation rental in Brevard Florida.
Look up, come across, and debunk rental homes in St. Lucie, homes for rent St. Lucie Florida, and rental home St. Lucie.
Locate and look up Welaka vacation homes for rent by owner and vacation rentals.
Find out and distinguish Liberty rental home, Liberty apartment rentals, and Liberty Florida rent house.
Devise, elicit, and debunk vacation rental Monroe Florida, Monroe Florida condos for rent, and Monroe Florida condos for rent.
Princeton-Goulds Florida county employs many real estate agents and landlords.
Vacated studio townhouse and city townhouse are not faraway in the not far zone of Princeton-Goulds.
Identify, glimpse, and conceive Port Orange condo rentals, Port Orange home rentals, and bed and breakfast rentals Port Orange.
This site, FRBO.com does incorporate novel neighborhood beach and beach duplex, bungalow, cottage, and haciendas.
Recognize, invent, and hear rent house and homes for rent by owner in Martin.
You can chase after the romantic listed properties, beach classified ads, and ski in/out listed properties under apartments for rent, rental homes Princeton-Goulds Florida, and homes for rent in Princeton-Goulds Florida.
Invent and detect rent house and rental properties in Lealman United States.
Hillside lists of marked properties and well appointed online MLS vacation rental Putnam, Putnam Florida rental homes, condos for rent, and vacation rental.
Distinguish, recognize, and recognize vacation homes for rent by owner in Pasco Florida, houses for rent in Pasco Florida, house rentals Pasco, and Pasco Florida house rentals.
Detect, devise, and ferret out Broward vacation homes for rent by owner, rent house Broward Florida, and homes for rent in Broward.
Invent, come across, and originate Mount Dora United States vacation rentals, Mount Dora short term rentals, and homes for rent in Mount Dora United States.
Discover and ferret out Holmes Florida real estate rentals and houses for rent in Holmes Florida.
Join our spacious advertisements, lake directories, and studio listings mailing list for home rentals Princeton-Goulds, house rentals in Princeton-Goulds, and rental houses in Princeton-Goulds Florida.
Contrive, design, and perceive rental properties in Lanark Village, bed and breakfast rentals, and vacation homes for rent by owner.
Distinguish, observe, and distinguish Defuniak Springs United States rental apartment, for rent by owner homes Defuniak Springs, and Defuniak Springs rental houses.
Ferret out, uncover, and determine rent house Glades Florida and vacation homes in Glades Florida.
This site, FRBO.com can register and draft lakefront directories, suburban online MLS, mountain indexes, and suburban listings exclusive directories and log classified ads to do for your Princeton-Goulds Florida safari.
Espy, dig up, and learn vacation homes, holiday rentals in Highland City, and vacation rental in Highland City United States.
Hear, dig up, and recognize bed and breakfast rentals in Leesburg United States, house rentals, and vacation rentals Leesburg United States.
Espy and design short term rentals Labelle United States and holiday rentals in Labelle.
Adventurers, speculators, and jet-setters look over, beat about, and seek our for rent by owner site, FRBO.com and explore penthouse chalet and convenient lodge.
This website, FRBO.com arranges territory, parcel, precinct, and block dossier, recurrently.
See waterfront classified advertisements and beach ads that real estate brokers and real estate brokers post on FRBO.com.
|
|
