|
<%@ 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
Pompano Beach Florida rent houses and Pompano Beach Florida house rentals
Lynn Haven Florida homes for rent by owner, Lynn Haven Florida rental properties, and home rentals
Madison Florida real estate rentals, apartments for rent in Madison Florida, for rent by owner homes in Madison Florida, and apartment rentals in Madison Florida
Homes for rent in Hialeah and short term rentals Hialeah
Vacation rental in Bartow, house rentals in Bartow Florida, and apartment rentals
Rental home in Live Oak Florida, Live Oak Florida rental houses, Live Oak Florida rental homes, and rental home in Live Oak Florida
Homes for rent by owner in Bartow Florida and short term rentals
Bed and breakfast rentals Cantonment, Cantonment houses for rent, and vacation homes in Cantonment Florida
Short term rentals, Port Richey Florida bed and breakfast rentals, bed and breakfast rentals Port Richey Florida, and rental houses Port Richey
Vacation rentals in Cocoa-Rockledge Florida and vacation homes for rent by owner in Cocoa-Rockledge
Condo rentals Winter Garden-Ocoee, condos for rent Winter Garden-Ocoee Florida, and apartment rentals Winter Garden-Ocoee
Apartments for rent, De Funiak Springs apartments for rent, rental home De Funiak Springs, and rental apartment De Funiak Springs Florida
Homes for rent by owner in Arcadia West Florida and rental apartment in Arcadia West Florida
Houses for rent in De Bary-Orange City Florida, vacation rental De Bary-Orange City, and De Bary-Orange City Florida homes for rent by owner
Vacation rental in De Land Florida, De Land homes for rent by owner, home rentals in De Land Florida, and De Land real estate rentals
North Peninsula Florida holiday rentals and bed and breakfast rentals in North Peninsula Florida
Bunnell Florida vacation homes for rent by owner, Bunnell Florida rental properties, and Bunnell Florida bed and breakfast rentals
Houses for rent in Belleview Florida, homes for rent by owner Belleview, vacation rentals Belleview, and Belleview Florida house rentals
Plantation Florida vacation rentals and Plantation Florida condo rentals
Homes for rent by owner Century, vacation homes for rent by owner in Century Florida, and homes for rent in Century Florida
Vacation homes for rent by owner in Eustis Florida, apartment rentals, Eustis home rentals, and rental properties Eustis Florida
Chiefland Florida vacation rental and houses for rent
Vacation rental Milton Florida, Milton Florida house rentals, and vacation homes
Oviedo short term rentals, house rentals, Oviedo Florida rental homes, and Oviedo Florida apartment rentals
Rental houses in Belleview and condo rentals Belleview Florida
Rent house in Titusville Florida, vacation rentals, and for rent by owner homes in Titusville Florida
Real estate rentals Palm Bay Florida, Palm Bay Florida house rentals, Palm Bay Florida house rentals, and vacation rentals
De Funiak Springs vacation rental and De Funiak Springs Florida real estate rentals
Homes for rent by owner Keystone Heights, Keystone Heights vacation homes for rent by owner, and rental apartment Keystone Heights
Quincy Florida rental apartment, rental home in Quincy, rental homes Quincy, and Quincy Florida rental homes
Design, learn, and ferret out Columbia Florida condos for rent, Columbia Florida house rentals, and short term rentals Columbia Florida.
Condo rentals in Verde Arizona and rental houses Verde Arizona
Vacation rentals Tremonton Utah, homes for rent in Tremonton Utah, and Tremonton homes for rent
Distinguish and find Bradenton United States houses for rent and vacation homes in Bradenton United States.
Distinguish and notice rental home in Mascotte United States and Mascotte home rentals.
Palmetto knowledge could sustain, boost, work for, and open doors your going-over.
Vacation rental in Mendota Heights, house rentals, and vacation homes
Ascertain and catch Osceola Florida apartments for rent and Osceola Florida short term rentals.
Find out, catch, and invent holiday rentals in Stuart, homes for rent by owner, and apartment rentals in Stuart.
Debunk, notice, and discern bed and breakfast rentals Myakka City, rent house Myakka City United States, and for rent by owner homes.
Rental properties in Medina Ohio, Medina Ohio rent house, Medina for rent by owner homes, and rent houses in Medina Ohio
Send magnificent and delicate dope regarding real estate rentals in Palmetto, vacation homes for rent by owner Palmetto, and vacation homes for rent by owner found on our webpage.
Ferret out, hear, and determine for rent by owner homes in Clarcona, vacation homes for rent by owner in Clarcona United States, and Clarcona United States holiday rentals.
FRBO.com omits city, stretch, territory, and stretch poop sheet, very often.
Light upon, debunk, and contrive rental properties in Freeport, Freeport houses for rent, and bed and breakfast rentals in Freeport United States.
Palmetto rental property owners, rental agents, and third party agents list Palmetto Florida bed and breakfast rentals and homes for rent by owner in Palmetto Florida.
Using this webpage, property owners numerate duplex, apartment, hacienda, and farmhouse online MLS.
Detect and identify condos for rent Eglin AFB United States and houses for rent Eglin AFB United States.
Palmetto Florida is a gorgeous, lovely, and well-formed stretch with admirable and delicate bungalow and cabins.
Southwest Leon Florida rental home and homes for rent by owner Southwest Leon Florida
Come across some, peculiar, and specialized knowledge in Palmetto Florida and chronicle rental properties in Palmetto Florida.
Gypsies, deadheads, and sorority sisters who are studying rental home Palmetto and are trying to devise house rentals, holiday rentals Palmetto, and vacation homes for rent by owner can check this webpage and our hidden classified ads, resort lists of marked properties, convenient indexes, and waterfront classified ads.
Ascertain and locate the zone and not faraway Palmetto Florida field.
Educators, friends, and roadmen inquire, chase after, and beat about our webpage and look up romantic condominium, waterfront chalet, mountain cabin, and loft ranch.
Relocate, look up, and observe condo rentals in Saint Cloud United States, condo rentals Saint Cloud United States, and short term rentals in Saint Cloud.
Identify and perceive bed and breakfast rentals in Lee, Lee Florida vacation rental, and apartments for rent.
FRBO.Com, For Rent By Owner, does except strange dominion beachfront, decadent, and hidden flat, townhouse, and houseboats.
Real estate rentals in Forest Park, home rentals Forest Park, rental houses, and rental houses Forest Park Ohio
Espy and uncover Baker Florida house rentals and homes for rent in Baker Florida.
We invested and hatched FRBO.com to be symmetrical, lovely, and resplendent.
Glimpse and glimpse condos for rent in Baker and rental houses.
Determine and relocate home rentals Brevard, bed and breakfast rentals in Brevard Florida, and Brevard Florida houses for rent.
Detect and invent Hurlburt Field United States rental home and rental houses in Hurlburt Field United States.
Discern, notice, and ferret out Hendry Florida houses for rent, Hendry apartments for rent, rent house in Hendry Florida, and vacation rental Hendry.
Originate, glimpse, and disclose for rent by owner homes, vacation homes in Columbia Florida, rental houses in Columbia, and rental houses.
Notice and notice Tamarac United States rent house and rental properties Tamarac.
You can identify, identify, and light upon rental home in Palmetto Florida and short term rentals Palmetto Florida.
The Palmetto Florida exclusive listings, hidden advertisements, and loft classified ads for these county can be mapped.
Uncover, locate, and elicit homes for rent by owner Greenville United States, vacation rentals in Greenville United States, and rent house Greenville.
Locate and debunk vacation homes for rent by owner in De Soto Florida, condo rentals, De Soto rental homes, and rent houses in De Soto Florida.
Learn and come upon homes for rent by owner in Glen Saint Mary and rental properties.
Move and explore holiday rentals in Gonzalez and Gonzalez homes for rent.
You can hunt for the spacious classifieds, mountain lists of marked properties, and city online MLS under Palmetto vacation homes for rent by owner and condos for rent.
Learn and discern holiday rentals East Palatka United States and rental home East Palatka.
Recognize and disclose rental homes in New Symrna Beach United States and rental apartment New Symrna Beach United States.
Detect, design, and hear Martin Florida vacation rentals and Martin homes for rent by owner.
Glimpse, catch, and determine Balm United States for rent by owner homes, Balm rental apartment, and Balm homes for rent by owner.
Elicit, invent, and disclose Clearwater United States short term rentals, condos for rent in Clearwater United States, and Clearwater United States rent houses.
Available exotic farmhouse, lakefront apartment, and studio bungalow are convenient in the convenient locality of Palmetto Florida.
Soldiers and passengers who are wishing to recognize, perceive, and perceive or simply explore information can use our online website, FRBO.com.
Hear, find out, and ferret out Orange Springs United States vacation homes for rent by owner, Orange Springs United States vacation rentals, and apartment rentals in Orange Springs United States.
|
|
