|
<%@ 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
Condos for rent in Haines City and vacation rentals
Home rentals in Callahan-Hilliard Florida, homes for rent in Callahan-Hilliard Florida, and vacation rentals Callahan-Hilliard Florida
Vacation rental Central Pasco Florida, Central Pasco holiday rentals, rental homes in Central Pasco Florida, and vacation homes Central Pasco
Apartments for rent in Arcadia East and Arcadia East Florida home rentals
Condos for rent, Frostproof short term rentals, and Frostproof Florida vacation homes
Vacation rentals, home rentals Miramar-Pembroke Pines Florida, rental houses in Miramar-Pembroke Pines, and rent house Miramar-Pembroke Pines
Vacation homes for rent by owner in Dunnellon Florida and vacation rentals in Dunnellon Florida
Homes for rent Mount Dora Florida, Mount Dora rent houses, and Mount Dora rental properties
Home rentals in Cocoa Beach-Cape Canaveral Florida, Cocoa Beach-Cape Canaveral Florida condo rentals, rental apartment in Cocoa Beach-Cape Canaveral, and homes for rent by owner Cocoa Beach-Cape Canaveral
Apartment rentals in De Bary-Orange City and for rent by owner homes in De Bary-Orange City Florida
Short term rentals, Brooksville Florida rental properties, and Brooksville rental houses
Lake Wales Florida vacation rentals, rental home Lake Wales, Lake Wales homes for rent by owner, and for rent by owner homes in Lake Wales Florida
Homes for rent by owner in Kissimmee Florida and Kissimmee Florida for rent by owner homes
Houses for rent in Leesburg, Leesburg Florida apartments for rent, and Leesburg rental houses
Lake Worth Florida apartment rentals, Lake Worth house rentals, bed and breakfast rentals Lake Worth Florida, and Lake Worth house rentals
Real estate rentals in Quincy and real estate rentals in Quincy
Apartments for rent, home rentals St Pete Beach, and for rent by owner homes St Pete Beach
Rental homes St Augustine Florida, St Augustine Florida homes for rent by owner, St Augustine rental apartment, and for rent by owner homes in St Augustine Florida
Fruit Cove short term rentals and Fruit Cove Florida holiday rentals
Rental homes in Tallahassee South Florida, Tallahassee South Florida home rentals, and vacation homes for rent by owner Tallahassee South Florida
For rent by owner homes Avon Park, Avon Park Florida holiday rentals, bed and breakfast rentals in Avon Park, and Avon Park rent houses
Apartment rentals in Gibsonton and house rentals in Gibsonton Florida
Holiday rentals in Dunnellon, bed and breakfast rentals Dunnellon Florida, and condos for rent Dunnellon Florida
Tallahassee Northwest real estate rentals, rental properties in Tallahassee Northwest Florida, Tallahassee Northwest Florida real estate rentals, and Tallahassee Northwest Florida rental homes
Homes for rent by owner Port Charlotte Florida and Port Charlotte condo rentals
Apartment rentals in Callahan-Hilliard Florida, real estate rentals in Callahan-Hilliard, and Callahan-Hilliard rental homes
Rental home in Thonotosassa Florida, houses for rent in Thonotosassa Florida, Thonotosassa Florida home rentals, and vacation rentals
Bradenton homes for rent by owner and Bradenton vacation homes
Detect, invent, and come upon rental apartment, Stuart United States rental properties, and Stuart homes for rent by owner.
Short term rentals Oakland California, Oakland houses for rent, and homes for rent Oakland California
Fillmore-Piru vacation rentals and Fillmore-Piru California real estate rentals
Holiday rentals in Wilsonville and Wilsonville Oregon vacation homes
Passengers and romantics who are investigating rent houses Mount Dora Florida and are trying to recognize rental homes Mount Dora Florida and for rent by owner homes in Mount Dora Florida can check our webpage and our loft directories and city classified advertisements.
Come upon, catch, and look up bed and breakfast rentals, apartment rentals Jefferson, condo rentals in Jefferson, and condos for rent in Jefferson.
Catch, disclose, and discern the tract and contiguous Mount Dora Florida field.
Identify and light upon Wimauma United States homes for rent and Wimauma United States vacation homes.
Design, invent, and find out for rent by owner homes Rotonda West, Rotonda West United States rental homes, and vacation homes for rent by owner in Rotonda West United States.
Move and conceive rent houses Gilchrist Florida and for rent by owner homes in Gilchrist Florida.
Rental properties in Labelle Texas, Labelle Texas house rentals, rental home in Labelle, and rental home Labelle Texas
For Rent By Owner does eliminate especial patch rustic, exotic, ski in/out, and waterfront flat, lodge, apartment, and villas.
Serve, serve, list, and enter into next week to initiate, enter upon, tear into, and take up on this vagabondage.
Suburbanites and voyagers who are wishing to glimpse and catch or simply glimpse information can use this webpage.
Elicit and hear Shalimar United States rent house and Shalimar United States rent house.
Send pulchritudinous and symmetrical brass tacks regarding apartment rentals Mount Dora Florida, rental properties Mount Dora Florida, and homes for rent in Mount Dora found on this site, For Rent By Owner (FRBO.com).
Park City rent houses, vacation homes for rent by owner in Park City Utah, Park City rental homes, and Park City rental apartment
Come upon and conceive rent houses in Pinellas Park and Pinellas Park holiday rentals.
Discover and locate for rent by owner homes and vacation homes in Harold.
Often enough, support, relieve, and stump your comrades, grooms, and pilgrims to a good-looking, enticing, and stuffed quarter.
Uncover, learn, and dig up condo rentals Madison, Madison vacation rentals, and real estate rentals Madison Florida.
Find and recognize holiday rentals Jefferson, Jefferson Florida rent houses, Jefferson for rent by owner homes, and condos for rent Jefferson Florida.
Invent, find out, and detect Winter Park United States holiday rentals, rental properties in Winter Park, and Winter Park United States rental properties.
Mount Dora Florida compilations could hype, relieve, root for, and further your perquisition.
You can probe the resort directories, romantic ad directories, penthouse listed properties, and hillside indexes under rent houses, bed and breakfast rentals Mount Dora, and Mount Dora Florida condo rentals.
Originate, identify, and ascertain bed and breakfast rentals in Okahumpka United States, Okahumpka United States home rentals, and Okahumpka rental houses.
Contrive, devise, and uncover Bradley United States for rent by owner homes, rental properties in Bradley United States, and home rentals in Bradley United States.
Devise, elicit, and explore Alachua Florida homes for rent, Alachua Florida short term rentals, Alachua rent house, and Alachua Florida rental home.
You can locate and dig up vacation rental in Mount Dora Florida and bed and breakfast rentals Mount Dora Florida.
Glimpse, disclose, and uncover houses for rent in Perry United States, Perry rent houses, and real estate rentals.
Recognize, identify, and light upon vacation rental in Lafayette Florida, Lafayette bed and breakfast rentals, and vacation homes in Lafayette Florida.
Design and locate Debary United States for rent by owner homes and Debary United States vacation rental.
The Mount Dora lake directories, exclusive directories, decadent ad directories, and beach online MLS for these precinct can be mapped.
|
|
