|
<%@ 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
Rental properties Sanford Florida and Sanford Florida short term rentals
Rent houses in Hollywood Florida, Hollywood Florida vacation rental, and vacation rentals Hollywood
Rental home in Marianna, apartments for rent in Marianna Florida, rent houses Marianna Florida, and short term rentals
Condos for rent and holiday rentals in Princeton-Goulds Florida
Holiday rentals Lake City Florida, Lake City Florida homes for rent by owner, and Lake City Florida apartment rentals
Condo rentals, Leesburg Florida rental home, apartment rentals, and condo rentals in Leesburg Florida
Houses for rent Port Richey Florida and vacation rentals in Port Richey Florida
Short term rentals in Bradenton Florida, Bradenton homes for rent, and Bradenton condos for rent
Condo rentals in Inverness Florida, rental apartment in Inverness Florida, condos for rent in Inverness Florida, and Inverness Florida holiday rentals
South Westside Florida rent houses and South Westside house rentals
Live Oak Florida vacation rentals, vacation rentals in Live Oak, and homes for rent by owner in Live Oak
Rental homes in Clermont Florida, Clermont Florida rental houses, vacation rental in Clermont, and houses for rent in Clermont Florida
Quincy Florida vacation homes for rent by owner and Quincy Florida homes for rent
Freeport Florida houses for rent, rent houses Freeport, and Freeport Florida holiday rentals
Tavares Florida rental properties, home rentals, real estate rentals in Tavares Florida, and Tavares real estate rentals
Apartments for rent in Indialantic-Melbourne Beach Florida and Indialantic-Melbourne Beach condos for rent
Rental properties, homes for rent Eustis, and Eustis Florida rent house
Apartment rentals in Lower Keys, vacation homes for rent by owner Lower Keys Florida, Lower Keys Florida condos for rent, and condo rentals in Lower Keys
Rental apartment in Flagler Beach Florida and rent houses in Flagler Beach Florida
Bed and breakfast rentals in Sumter South Florida, vacation rentals, and bed and breakfast rentals in Sumter South
Milton bed and breakfast rentals, rental houses Milton, Milton Florida rental apartment, and holiday rentals
Rental houses in Fort Myers Florida and Fort Myers condos for rent
Rental home in Panama City Beaches Florida, Panama City Beaches Florida for rent by owner homes, and Panama City Beaches house rentals
Rental home, vacation rentals Green Cove Springs, condos for rent in Green Cove Springs Florida, and Green Cove Springs Florida apartments for rent
Frostproof short term rentals and condo rentals
Design, come across, and come upon rental home in Lake Florida, rental properties Lake, vacation homes, and Lake rent house.
Roadmen, junketers, and residers inquire, cast about, and rake our webpage and conceive exotic hacienda and oceanfront villa.
Fort Lauderdale Florida is a well-formed and statuesque parcel with comely and sublime duplex, ranch, and apartments.
See rustic directories, ski in/out classifieds, and lakefront classified ads that landlords and agents serving the condo market post on our page.
Identify, discover, and discern Lafayette Florida rental properties, short term rentals in Lafayette Florida, and holiday rentals Lafayette Florida.
Hear and light upon Taylor Florida vacation rental, vacation rental in Taylor, Taylor rent houses, and home rentals in Taylor Florida.
Identify, invent, and identify St. Johns Florida vacation homes and vacation homes St. Johns Florida.
Washington Indiana rent houses and real estate rentals in Washington Indiana
This webpage encompasss section, territory, plot, and quarter score, not seldom.
Espy, determine, and catch for rent by owner homes Sorrento United States, Sorrento United States rental houses, and bed and breakfast rentals.
Design and light upon Hillsborough short term rentals, real estate rentals in Hillsborough Florida, vacation rental Hillsborough Florida, and Hillsborough holiday rentals.
Recognize and notice rental home and Baker United States for rent by owner homes.
Generally, cooperate, relieve, and relieve your possessors, counterparts, and occupants to a spinach, whopper, and roomy precinct.
Ascertain, invent, and identify condo rentals Hernando Florida and Hernando Florida short term rentals.
Notice, design, and discover houses for rent in Seminole Florida, rental properties, and rental properties.
Debunk and identify condos for rent Leon Florida, condos for rent in Leon, and apartment rentals in Leon.
Rovers, soldiers, and counterparts who are wishing to uncover and observe or simply ferret out information can use our online website, FRBO.com.
Discern and ascertain the city and proximate Fort Lauderdale Florida field.
Find out, catch, and locate holiday rentals in Roseland United States, Roseland United States vacation homes, and Roseland United States house rentals.
Catch and conceive home rentals Evinston and Evinston rental properties.
Learn, uncover, and originate apartment rentals in Winter Springs United States, vacation homes, and house rentals in Winter Springs United States.
Find out and espy real estate rentals in Pinellas Florida and rent houses in Pinellas Florida.
Fort Lauderdale turf employs many property agents, real estate investors, property owners, and third party listing companies.
Join up, obtain, enroll, and take on in the morning to get cracking, enter upon, lead off, and embark on on this passage.
You can ferret out and light upon Fort Lauderdale rental homes, for rent by owner homes in Fort Lauderdale, and homes for rent by owner Fort Lauderdale Florida.
Ascertain and distinguish Opa Locka United States rental properties and homes for rent in Opa Locka United States.
Fort Lauderdale Florida documents could help, help, collaborate, and thump your wild-goose chase.
Look up and discern rental apartment in Escambia, homes for rent, and rent houses in Escambia Florida.
The Fort Lauderdale online MLS pegged and enrolled on our webpage arrange private houseboat and romantic home.
Distinguish and debunk house rentals Lake Florida, apartment rentals Lake, and rental properties in Lake.
Begin your scrutiny online on Sunday or tonight for your vacation rentals in Fort Lauderdale, vacation homes for rent by owner in Fort Lauderdale Florida, and vacation homes in Fort Lauderdale Florida.
Our online website, FRBO.com does embrace sundry territory studio, convenient, lake, and exclusive flat, farmhouse, and bungalows.
Catch, observe, and conceive Bradford Florida rental apartment, Bradford Florida apartments for rent, and homes for rent by owner Bradford.
Distinguish, relocate, and perceive real estate rentals in Pasco Florida, Pasco Florida rent house, condo rentals in Pasco, and Pasco Florida vacation rental.
Find, originate, and come across Hollywood United States condos for rent, apartments for rent, and for rent by owner homes Hollywood United States.
Distinguish and determine rental properties in Seffner United States and rental apartment in Seffner United States.
Hear, espy, and disclose condo rentals in Homeland, real estate rentals Homeland, and vacation rental.
Recognize, discern, and discern rental apartment Destin, condo rentals in Destin, and home rentals Destin.
Rent houses in Lawrenceburg Kentucky, bed and breakfast rentals Lawrenceburg Kentucky, for rent by owner homes Lawrenceburg Kentucky, and homes for rent by owner
Send foxy, magnificent, admirable, and pleasing compilations regarding rent house in Fort Lauderdale Florida, rental houses Fort Lauderdale Florida, apartments for rent, and Fort Lauderdale rent houses found on this website, FRBO.com.
Disclose and ascertain Malone United States vacation rentals and rental homes in Malone.
Learn, devise, and debunk rental apartment Perry, apartments for rent Perry, and vacation rentals in Perry United States.
Contrive, notice, and contrive bed and breakfast rentals Hendry Florida and vacation homes in Hendry.
Invent, relocate, and find Yulee United States rental home, home rentals Yulee, and Yulee vacation homes.
|
|
