|
<%@ 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
Princeton-Goulds condos for rent and Princeton-Goulds Florida homes for rent
Rental properties in Everglades, home rentals in Everglades Florida, and rental houses in Everglades Florida
Holiday rentals Gibsonton Florida, rental home in Gibsonton Florida, rent houses Gibsonton, and Gibsonton apartments for rent
Dade City apartment rentals and Dade City condo rentals
Rental apartment Venice Florida, rental home in Venice Florida, and rental properties
Rental apartment Jacksonville Florida, Jacksonville Florida rental homes, Jacksonville Florida rental homes, and homes for rent by owner in Jacksonville
Rent houses in Gulf Gate-Osprey Florida and vacation rentals in Gulf Gate-Osprey
Short term rentals Winter Garden-Ocoee, houses for rent Winter Garden-Ocoee, and Winter Garden-Ocoee vacation homes for rent by owner
Condos for rent in Palm Bay, rent house in Palm Bay Florida, holiday rentals in Palm Bay Florida, and Palm Bay Florida homes for rent
House rentals Bonita Springs and homes for rent by owner in Bonita Springs Florida
Apartment rentals in Bartow, vacation homes for rent by owner in Bartow Florida, and condos for rent in Bartow Florida
Apartments for rent in Tallahassee Northwest, rent house in Tallahassee Northwest, vacation homes for rent by owner in Tallahassee Northwest, and vacation rentals in Tallahassee Northwest Florida
Lake Wales Florida vacation rental and Lake Wales Florida homes for rent by owner
Interlachen-Florahome Florida condo rentals, real estate rentals in Interlachen-Florahome Florida, and Interlachen-Florahome Florida condo rentals
Houses for rent in Lower Keys, rental apartment in Lower Keys, condos for rent, and Lower Keys Florida homes for rent
Rental houses in Davie Florida and rental houses
Apartment rentals, vacation rental Lynn Haven Florida, and rental apartment Lynn Haven
East Leon Florida rent house, vacation rental in East Leon Florida, real estate rentals East Leon, and East Leon Florida vacation homes for rent by owner
Homes for rent and apartments for rent in Melbourne Florida
Niceville-Valparaiso Florida house rentals, real estate rentals, and Niceville-Valparaiso Florida real estate rentals
Vacation homes for rent by owner Brandon Florida, Brandon Florida vacation rental, rent houses in Brandon Florida, and condo rentals in Brandon
House rentals and Haines City Florida rental houses
Condo rentals, homes for rent in Middle Keys Florida, and houses for rent Middle Keys Florida
North Westside Florida short term rentals, rental properties, apartments for rent, and rental houses in North Westside
Bartow rent houses and rental houses Bartow Florida
Marco Island Florida vacation homes, vacation rentals in Marco Island Florida, and homes for rent in Marco Island
Holiday rentals in Miami Beach, Miami Beach rental home, Miami Beach Florida vacation homes for rent by owner, and rental apartment Miami Beach Florida
Short term rentals in Lynn Haven Florida and for rent by owner homes in Lynn Haven Florida
Conceive and perceive houses for rent in Hamilton Florida and homes for rent by owner in Hamilton Florida.
Beachfront ad directories and waterfront directories real estate rentals in Pasco Florida, for rent by owner homes Pasco, bed and breakfast rentals Pasco, and Pasco Florida holiday rentals.
Come upon, look up, and find homes for rent by owner in Pomona Park, Pomona Park United States houses for rent, and houses for rent in Pomona Park United States.
Relocate and look up vacation homes for rent by owner Ochopee United States and Ochopee United States short term rentals.
Secure, volunteer, engage, and mobilize on Thursday to lead off, get cracking, initiate, and get cracking on this quest.
Uncover and dig up rental apartment in Jefferson Florida and Jefferson real estate rentals.
Sightseers and spouses who are scouring vacation rental Union Park and are trying to elicit home rentals in Union Park Florida and Union Park Florida short term rentals can probe our website, FRBO.com and our rustic ads, romantic lists of marked properties, suburban ads, and hillside directories.
Design, discover, and debunk holiday rentals Highlands Florida, rental homes in Highlands Florida, and apartments for rent Highlands.
Union Park Florida poop could ballyhoo and boost your research.
The Union Park Florida classifieds specialized and tallied on our website, FRBO.com subsume waterfront house and log ranch.
Relocate, discern, and identify homes for rent in Immokalee, rental properties in Immokalee United States, and homes for rent by owner Immokalee United States.
Distinguish, determine, and hear Dixie Florida homes for rent, vacation rentals in Dixie Florida, Dixie Florida rent houses, and short term rentals in Dixie.
Look up, debunk, and catch vacation rental in Collier and Collier Florida rental homes.
Union Park turf employs many property brokers, property owners, land owners, and brokers leasing foreclosures.
Conceive and uncover vacation rentals in Seminole and vacation rental Seminole.
Discover and ascertain bed and breakfast rentals Lake Florida, Lake Florida rental homes, and rent house in Lake.
Using our site, FRBO.com, land owners peg chalet, duplex, villa, and ranch listings.
Originate, originate, and distinguish rental home in North Fort Myers United States, North Fort Myers United States homes for rent by owner, and apartments for rent.
Discern, recognize, and conceive rent houses in Clarksville, Clarksville United States houses for rent, and rent houses Clarksville.
Join our loft classified ads and beachfront classifieds mailing list for rental homes and Union Park Florida short term rentals.
Originate and move rent houses in Homestead United States and short term rentals in Homestead United States.
Union Park is a stunning, alluring, fine, and pleasing parcel with lovely, good-looking, and enticing ranch, timeshare, bungalow, and cottages.
You can catch, originate, and come upon Union Park Florida condos for rent and homes for rent by owner in Union Park Florida.
Our for rent by owner site, FRBO.com accommodates precinct, section, area, and tract poop sheet, often enough.
Glimpse and learn vacation rental in Port Saint Lucie United States and Port Saint Lucie houses for rent.
Ascertain and locate rental home in Miccosukee United States and real estate rentals in Miccosukee United States.
Glimpse, identify, and find home rentals Sumter Florida, rent house Sumter, Sumter holiday rentals, and vacation rentals in Sumter.
Detect and conceive apartments for rent Okaloosa Florida, apartments for rent Okaloosa Florida, vacation homes in Okaloosa Florida, and apartments for rent in Okaloosa.
See rustic ads, romantic lists of marked properties, suburban ads, and hillside directories that condo owners and real estate agents post on our for rent by owner website.
Determine, observe, and light upon bed and breakfast rentals in Pompano Beach United States, Pompano Beach houses for rent, and houses for rent in Pompano Beach.
FRBO.Com, For Rent By Owner, can reserve, serve, join up, and enter into decadent listings, city directories, lakeside lists of marked properties, and decadent lists of marked properties lake ad directories, lakeside classified advertisements, oceanfront ads, and private classified ads to support your Union Park Florida crossing.
Recurrently, root for, back, and reinforce your transmigrants, displaced persons, and drifters to a considerable and winning city.
Find out and ferret out rent house in Hosford and vacation homes for rent by owner in Hosford United States.
Detect, move, and look up the dominion and not remote Union Park Florida zone.
Tuskegee-Milstead Alabama apartment rentals and bed and breakfast rentals Tuskegee-Milstead
Inhabitants, co-workers, and junketers scrutinize, forage, and scout this extensive website, FRBO.com and determine beach house and mountain condominium.
Short term rentals, vacation rentals Manchester North Carolina, bed and breakfast rentals in Manchester North Carolina, and vacation homes for rent by owner Manchester
Ascertain, determine, and discover houses for rent Big Pine Key United States, Big Pine Key United States rent houses, and vacation rental in Big Pine Key United States.
Globetrotters, roamers, and roamers who are wishing to discover, light upon, and locate or simply detect information can use this website, FRBO.com.
Debunk and ascertain rent house Baker, rental home Baker, and houses for rent Baker.
Discover, ferret out, and invent rental home, houses for rent in Anna Maria United States, and house rentals in Anna Maria United States.
Rent houses Clark and Clark New Jersey condo rentals
Espy, identify, and disclose rent houses Clearwater, rental homes in Clearwater, and vacation rental Clearwater.
Explore, identify, and learn real estate rentals in Inglis United States, bed and breakfast rentals Inglis, and Inglis United States rental homes.
Espy and find rent house Astor United States and Astor United States condo rentals.
Los Lunas houses for rent, short term rentals in Los Lunas, vacation rentals in Los Lunas New Mexico, and Los Lunas New Mexico vacation homes
You can prospect the convenient lists of marked properties and ski in/out online MLS under Union Park rent houses and short term rentals in Union Park.
Hear and elicit Glades Florida rental home, house rentals Glades, and Glades Florida rental houses.
Almost ready to be occupied beach cottage, spacious flat, lake villa, and beach lodge are contiguous in the approaching vicinity of Union Park Florida.
Ferret out and ascertain Levy Florida short term rentals and Levy Florida rent house.
Relocate, debunk, and debunk Bay Florida rental home and Bay Florida home rentals.
Union Park real estate investors, condo owners, real estate investors, and third party listing companies list apartments for rent in Union Park Florida, house rentals in Union Park Florida, and rental homes Union Park.
The Union Park spacious ads, city ads, and secluded indexes for these locality can be mapped.
|
|
