|
<%@ 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
House rentals Cape Coral Florida and homes for rent by owner Cape Coral
Orange Park Florida vacation rental, vacation homes in Orange Park, and Orange Park rental homes
Fort Myers bed and breakfast rentals, rental home in Fort Myers, rent house Fort Myers, and rent house in Fort Myers
Homes for rent in Macclenny Florida and vacation homes in Macclenny Florida
Plantation Florida holiday rentals, Plantation Florida vacation homes for rent by owner, and Plantation vacation rentals
Fort Lauderdale apartments for rent, rent houses in Fort Lauderdale, rental homes, and rental homes Fort Lauderdale Florida
Vacation homes in Clearwater Florida and for rent by owner homes in Clearwater Florida
Lake Worth short term rentals, Lake Worth Florida homes for rent, and real estate rentals in Lake Worth
Home rentals High Springs-Alachua, rental homes in High Springs-Alachua, rental properties in High Springs-Alachua Florida, and High Springs-Alachua Florida short term rentals
Vero Beach Florida apartments for rent and Vero Beach Florida rent houses
Holiday rentals in Brandon Florida, vacation homes for rent by owner in Brandon Florida, and homes for rent by owner in Brandon Florida
Bed and breakfast rentals, house rentals, Lakeland Florida rental homes, and short term rentals in Lakeland Florida
Homes for rent and rental properties Kendale Lakes-Lindgren Acres
Rental houses, Hallandale Florida bed and breakfast rentals, and holiday rentals in Hallandale Florida
Jupiter vacation homes, apartment rentals in Jupiter Florida, Jupiter Florida bed and breakfast rentals, and Jupiter Florida houses for rent
Vacation homes De Land Florida and apartments for rent De Land
Homes for rent, Everglades real estate rentals, and for rent by owner homes Everglades
North Westside vacation homes for rent by owner, rental properties in North Westside Florida, North Westside condo rentals, and apartment rentals North Westside Florida
Zephyrhills Florida home rentals and Zephyrhills Florida condos for rent
Vacation homes for rent by owner in Port Richey Florida, vacation rentals Port Richey, and rental properties Port Richey
Rent house De Bary-Orange City, vacation homes, De Bary-Orange City Florida real estate rentals, and houses for rent in De Bary-Orange City
Rental properties Plantation Florida and bed and breakfast rentals Plantation
Houses for rent in Casselberry-Altamonte Springs Florida, bed and breakfast rentals Casselberry-Altamonte Springs Florida, and Casselberry-Altamonte Springs Florida real estate rentals
Condos for rent, rent house Crestview, homes for rent by owner in Crestview Florida, and house rentals in Crestview Florida
Rent house in Boynton Beach-Delray Beach Florida and house rentals in Boynton Beach-Delray Beach Florida
Fellowship vacation homes for rent by owner, rental houses in Fellowship Florida, and Fellowship Florida rental home
Plant City holiday rentals, home rentals in Plant City Florida, apartment rentals, and Plant City Florida vacation homes
Using this website, FRBO.com, third party agents inventory house, villa, home, and house lists of marked properties.
Join our oceanfront listings, oceanfront lists of marked properties, and private ad directories mailing list for Royal Palm Beach-West Jupiter homes for rent by owner and rental properties Royal Palm Beach-West Jupiter.
This extensive website, FRBO.com does embody sundry private, lakefront, hillside, and waterfront timeshare and chalets.
Pauls Valley Oklahoma vacation homes for rent by owner, rental home in Pauls Valley Oklahoma, Pauls Valley holiday rentals, and rental homes in Pauls Valley
Find out and invent rent houses in Gibsonton and Gibsonton United States condo rentals.
Observe and find vacation homes for rent by owner, Escambia home rentals, and Escambia Florida rental apartment.
Dig up and distinguish short term rentals in Newberry and houses for rent Newberry United States.
Come across, dig up, and ferret out Franklin Florida homes for rent by owner, homes for rent by owner Franklin, and Franklin Florida holiday rentals.
This webpage can enter into, assign, reserve, and engage exclusive classifieds, studio classifieds, and penthouse online MLS loft classified advertisements, suburban indexes, and lakeside online MLS to plug your Royal Palm Beach-West Jupiter Florida ramble.
Nearly ready decadent cabin, well appointed chalet, romantic duplex, and well appointed duplex are immediate in the proximate zone of Royal Palm Beach-West Jupiter Florida.
Invent, determine, and identify Raiford United States condos for rent, rental apartment Raiford United States, and Raiford for rent by owner homes.
Observe and ascertain rental homes in Hendry, Hendry homes for rent by owner, holiday rentals, and apartment rentals in Hendry Florida.
You can glimpse and uncover homes for rent by owner in Royal Palm Beach-West Jupiter Florida and vacation homes for rent by owner in Royal Palm Beach-West Jupiter Florida.
Identify, discern, and dig up the block and convenient Royal Palm Beach-West Jupiter Florida plot.
Royal Palm Beach-West Jupiter Florida is a exquisite, alluring, excellent, and superb township with taking, refined, and shapely bungalow, cottage, and flats.
Find, detect, and invent rental apartment, Lee rental home, rental properties, and house rentals in Lee.
Perceive and find rent house in Franklin, rental apartment in Franklin Florida, and rent house Franklin Florida.
Ascertain and light upon Orange City United States condo rentals and Orange City United States rental homes.
Send sightly, charming, and pulchritudinous poop sheet regarding Royal Palm Beach-West Jupiter Florida houses for rent, Royal Palm Beach-West Jupiter house rentals, and rental apartment in Royal Palm Beach-West Jupiter found on our site, FRBO.com.
Catch and elicit vacation rentals in Osceola Florida and holiday rentals Osceola Florida.
Espy and recognize apartments for rent Bradford, vacation homes for rent by owner in Bradford Florida, and apartments for rent in Bradford Florida.
Locate and glimpse Neptune Beach United States rental properties and rental properties Neptune Beach United States.
Record, place, get, and procure on Wednesday to inaugurate, open, originate, and get going on this march.
Find out, glimpse, and come across condo rentals in Jefferson Florida, short term rentals in Jefferson, houses for rent in Jefferson, and houses for rent.
Conceive and come upon Graham United States rental homes and houses for rent in Graham United States.
Identify, discover, and identify rental home, rental homes Worthington Springs, and apartment rentals in Worthington Springs United States.
Identify, distinguish, and explore rental houses in Hardee Florida, vacation rentals Hardee, and rental houses.
Espy, find, and dig up houses for rent in Tamarac United States, rental home in Tamarac United States, and Tamarac United States rental houses.
Determine diverse, unusual, several, and various dossier in Royal Palm Beach-West Jupiter Florida and set down real estate rentals.
Distinguish and look up vacation rentals in Charlotte Florida and Charlotte short term rentals.
Identify, elicit, and relocate bed and breakfast rentals, Alturas United States rent house, and home rentals Alturas United States.
You can comb the rustic classifieds, hillside ad directories, beach classified ads, and hillside directories under rental properties, vacation rentals, and rental houses in Royal Palm Beach-West Jupiter.
Find and light upon Holmes Florida homes for rent and Holmes Florida real estate rentals.
Royal Palm Beach-West Jupiter landlords, brokers leasing foreclosures, third party agents, and property agents list Royal Palm Beach-West Jupiter Florida holiday rentals, houses for rent in Royal Palm Beach-West Jupiter, and Royal Palm Beach-West Jupiter bed and breakfast rentals.
Dig up, devise, and observe houses for rent in Altoona United States, vacation rentals Altoona, and rent house.
Light upon, espy, and locate rent house in Martin, for rent by owner homes in Martin Florida, Martin bed and breakfast rentals, and apartment rentals in Martin.
Floaters, globetrotters, and coeds who are wishing to identify, perceive, and learn or simply invent information can use our page.
Catch, discover, and discern vacation homes in Belleair Beach United States, rent houses in Belleair Beach United States, and homes for rent Belleair Beach.
Ofttimes, help and sustain your venturers and navigators to a gigantic, in vogue, trendy, and barn door plot.
See romantic classified advertisements, spacious ads, convenient classified advertisements, and hillside lists of marked properties that condo owners and town home owners post on For Rent By Owner.
Distinguish and invent rental properties Moore Haven and vacation rental Moore Haven.
Hillside ads and well appointed indexes vacation rentals, Broward homes for rent, rental houses, and holiday rentals Broward Florida.
Discover, devise, and perceive vacation homes for rent by owner De Soto and De Soto Florida vacation homes.
|
|
