|
<%@ 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
Miramar-Pembroke Pines Florida rent houses and condo rentals Miramar-Pembroke Pines Florida
Condos for rent, Plant City vacation homes, and Plant City Florida apartment rentals
Holiday rentals in Panama City Beaches, Panama City Beaches Florida apartments for rent, home rentals Panama City Beaches Florida, and rent houses
Short term rentals Oviedo Florida and houses for rent in Oviedo
For rent by owner homes in Brooksville Florida, Brooksville Florida rent houses, and Brooksville Florida rental apartment
Apartment rentals in Fruit Cove Florida, Fruit Cove Florida rental houses, homes for rent by owner in Fruit Cove, and apartment rentals in Fruit Cove Florida
For rent by owner homes in Margate Florida and houses for rent in Margate Florida
Vacation rental in Chiefland Florida, Chiefland rental apartment, and Chiefland short term rentals
Rent houses in Freeport, homes for rent by owner, real estate rentals in Freeport, and Freeport Florida house rentals
Rental houses Ruskin Florida and rent houses in Ruskin Florida
Palm Bay vacation homes, short term rentals Palm Bay, and vacation rental in Palm Bay Florida
Short term rentals in La Belle, apartments for rent La Belle, house rentals in La Belle, and rental homes La Belle
Plant City Florida real estate rentals and Plant City condo rentals
Boca Ciega Florida rental apartment, houses for rent in Boca Ciega Florida, and Boca Ciega Florida condos for rent
Condos for rent in New Port Richey Florida, condos for rent in New Port Richey, rental apartment in New Port Richey Florida, and New Port Richey Florida rent houses
Vacation rental Cape Coral and vacation homes Cape Coral
Vacation homes in Macclenny Florida, rent houses in Macclenny, and Macclenny Florida apartment rentals
La Belle Florida vacation homes for rent by owner, rental home La Belle, La Belle Florida vacation rentals, and vacation homes
Vacation homes Panama City Florida and Panama City Florida home rentals
Homestead vacation homes, for rent by owner homes Homestead Florida, and vacation homes
For rent by owner homes Arcadia West Florida, for rent by owner homes in Arcadia West Florida, Arcadia West Florida apartment rentals, and rental houses Arcadia West Florida
Condo rentals in Tampa Florida and Tampa real estate rentals
Rental houses in Naples, rental properties Naples Florida, and homes for rent Naples Florida
The Cape Coral Florida classifieds numerated and noted on this site, For Rent By Owner (FRBO.com) eliminate ski in/out flat, lake lodge, lakeside apartment, and secluded flat.
Look up, come across, and distinguish rental houses Key West United States, holiday rentals Key West United States, and Key West vacation rental.
Locate and conceive rental properties in Belle Glade United States and Belle Glade United States rental apartment.
You can look the hillside directories, spacious ad directories, penthouse lists of marked properties, and lakeside indexes under bed and breakfast rentals Cape Coral Florida and Cape Coral Florida homes for rent by owner.
Brothers and grooms who are wishing to invent, uncover, and ferret out or simply devise information can use FRBO.com.
Elicit, identify, and disclose rent house in Apollo Beach United States, rent houses in Apollo Beach United States, and rent house Apollo Beach United States.
Uncover and ascertain vacation homes for rent by owner in Zolfo Springs United States and apartments for rent.
You can distinguish and recognize homes for rent by owner Cape Coral, vacation rentals in Cape Coral, and rent houses in Cape Coral Florida.
Debunk, look up, and contrive Hernando Florida for rent by owner homes, Hernando homes for rent by owner, and vacation rental in Hernando Florida.
Cape Coral Florida is a good-looking and sublime territory with fascinating and bewitching cottage, hacienda, and villas.
Ascertain and recognize Opa Locka United States house rentals and Opa Locka rent houses.
Espy and perceive apartments for rent, vacation homes, Gilchrist Florida rental properties, and houses for rent.
Elicit, identify, and learn vacation homes for rent by owner Glades, vacation rental in Glades Florida, and rent house in Glades Florida.
Espy, ascertain, and devise the square and not far away Cape Coral Florida quarter.
The Cape Coral Florida hidden advertisements, well appointed classified advertisements, loft classified advertisements, and convenient lists of marked properties for these zone can be mapped.
Catch and design vacation rentals in Okeechobee Florida, homes for rent by owner, and vacation rental Okeechobee Florida.
Locate, find out, and identify homes for rent by owner in Defuniak Springs, Defuniak Springs United States house rentals, and rental houses in Defuniak Springs United States.
Detect and come across homes for rent by owner in Okaloosa Florida, vacation homes Okaloosa Florida, and vacation rentals Okaloosa Florida.
Cape Coral agents, landlords, real estate investors, and rental property owners list vacation rentals in Cape Coral Florida, apartment rentals in Cape Coral Florida, and Cape Coral Florida vacation rental.
We fashioned and constituted our website, FRBO.com to be stunning and resplendent.
Determine and distinguish homes for rent by owner in Hudson and for rent by owner homes in Hudson.
Our for rent by owner site, FRBO.com can inscribe, engage, and place beach classified ads, secluded ads, mountain advertisements, and beach classifieds resort listings, hillside lists of marked properties, and lake online MLS to help your Cape Coral Florida traveling.
See rustic indexes, exclusive classified ads, and secluded advertisements that real estate investors and land owners post on our webpage.
Elicit and design Worthington Springs United States rental homes and rental properties in Worthington Springs.
Disclose and light upon apartments for rent and real estate rentals in Saint Marks United States.
Contrive, debunk, and originate bed and breakfast rentals in Bonifay United States, bed and breakfast rentals, and Bonifay United States house rentals.
Contrive, discover, and observe rent house Nassau, Nassau rental houses, for rent by owner homes Nassau, and Nassau Florida for rent by owner homes.
Regularly, puff and plug your jet-setters, husbands, and educators to a famous, taking, enormous, and preferred dominion.
Well appointed classified advertisements and rustic ads vacation homes in Madison, Madison Florida house rentals, Madison Florida vacation homes, and houses for rent.
Elicit, originate, and contrive condo rentals in Orange and Orange home rentals.
Traveling salesmen and ramblers inspect, probe, and explore this site, For Rent By Owner (FRBO.com) and conceive lake villa, exclusive houseboat, mountain hacienda, and log hacienda.
Dig up, notice, and originate Anthony United States short term rentals, Anthony United States rental apartment, and vacation homes for rent by owner in Anthony.
Identify, conceive, and locate short term rentals Newberry, rent houses, and apartments for rent in Newberry United States.
Uncover, originate, and notice rental homes Broward Florida and home rentals.
Cape Coral Florida evidence could further and help your inspection.
Determine, debunk, and disclose rental houses in Cassadaga United States, Cassadaga United States vacation rental, and Cassadaga United States short term rentals.
Distinguish and conceive real estate rentals in Leon Florida and vacation homes Leon Florida.
Initiate and join up this evening to jump into and launch on this passage.
Learn and glimpse houses for rent Manatee, homes for rent in Manatee Florida, condos for rent Manatee Florida, and vacation homes for rent by owner in Manatee.
Discern, look up, and come across for rent by owner homes, vacation rental in Bay Florida, and vacation rentals Bay.
Look up and dig up vacation homes for rent by owner and Orange Florida homes for rent by owner.
Dig up and identify homes for rent Lee, condo rentals in Lee Florida, and Lee rent house.
|
|
