|
<%@ 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
Vacation rentals in Venice Florida and rent house in Venice Florida
Rental homes in Ormond Beach Florida, Ormond Beach Florida vacation homes, and homes for rent in Ormond Beach Florida
Home rentals New Smyrna Beach Florida, New Smyrna Beach Florida vacation rentals, vacation rental New Smyrna Beach Florida, and New Smyrna Beach Florida vacation rentals
Apartments for rent in Sumter South Florida and vacation rentals
Vacation homes for rent by owner in Fort McCoy-Anthony Florida, rental houses in Fort McCoy-Anthony, and Fort McCoy-Anthony Florida apartments for rent
Sping Hill Florida vacation homes, apartments for rent in Sping Hill Florida, houses for rent in Sping Hill, and vacation homes
Apartment rentals and Crescent City short term rentals
Rent houses Sumter South, rental home in Sumter South, and condo rentals in Sumter South
For rent by owner homes, Everglades apartments for rent, Everglades Florida short term rentals, and homes for rent by owner in Everglades
Home rentals in Cross City North Florida and condo rentals Cross City North Florida
Real estate rentals in Fort Myers Florida, rental properties, and Fort Myers Florida homes for rent by owner
Marianna Florida vacation rentals, condos for rent in Marianna, Marianna vacation homes for rent by owner, and rent houses in Marianna Florida
Callahan-Hilliard Florida condo rentals and Callahan-Hilliard Florida for rent by owner homes
Rent houses, houses for rent in Royal Palm Beach-West Jupiter, and Royal Palm Beach-West Jupiter Florida vacation rental
Rent house Bartow Florida, apartment rentals Bartow Florida, Bartow home rentals, and vacation rental Bartow Florida
Apartments for rent in Century Florida and vacation rentals Century Florida
Indialantic-Melbourne Beach Florida home rentals, vacation rentals, and Indialantic-Melbourne Beach Florida for rent by owner homes
House rentals Fort Lauderdale Florida, homes for rent in Fort Lauderdale Florida, Fort Lauderdale Florida apartments for rent, and houses for rent Fort Lauderdale
Short term rentals in Howey-in-the-Hills-Okahumpka Florida and Howey-in-the-Hills-Okahumpka Florida rental apartment
Bed and breakfast rentals Lakeland Florida, house rentals Lakeland, and apartments for rent in Lakeland
Vacation homes in Cape Coral Florida, bed and breakfast rentals in Cape Coral, vacation homes for rent by owner in Cape Coral Florida, and rental homes in Cape Coral Florida
Winter Garden-Ocoee condo rentals and holiday rentals Winter Garden-Ocoee Florida
Apartments for rent in La Belle, rent houses in La Belle Florida, and La Belle Florida rental homes
For rent by owner homes, house rentals Okeechobee Florida, Okeechobee Florida home rentals, and rent house in Okeechobee
Vacation homes for rent by owner and St Pete Beach Florida short term rentals
Rental home Sumter South Florida, Sumter South vacation rentals, and houses for rent Sumter South Florida
Debunk, discern, and catch vacation rental, short term rentals in St. Lucie Florida, and house rentals.
Observe and debunk rent houses Minneola United States and rental properties Minneola United States.
Dwellers and roamers prospect and scrutinize our webpage and hear exclusive flat, suburban home, and studio vacation home.
Invent, ascertain, and come across apartments for rent in Winter Garden, for rent by owner homes Winter Garden United States, and Winter Garden United States bed and breakfast rentals.
Empty private townhouse and hillside duplex are abutting in the near-at-hand sector of High Springs-Alachua.
Find, notice, and uncover Groveland houses for rent, homes for rent by owner in Groveland United States, and home rentals Groveland United States.
Explore, design, and identify house rentals, Parrish United States rent houses, and rental properties in Parrish.
Send well-formed and ravishing facts regarding holiday rentals in High Springs-Alachua, apartments for rent in High Springs-Alachua Florida, rental homes High Springs-Alachua Florida, and rent houses in High Springs-Alachua Florida found on our page.
Uncover and ascertain rental home in Brooker United States and Brooker rent house.
High Springs-Alachua real estate brokers, property managers, real estate brokers, and rental property owners list vacation homes for rent by owner, vacation homes for rent by owner, High Springs-Alachua Florida rental houses, and short term rentals High Springs-Alachua Florida.
The High Springs-Alachua listed properties written down and enumerated on this webpage seat lakefront castle and city castle.
Relocate, distinguish, and catch apartment rentals and Calhoun Florida house rentals.
Design, discern, and ferret out vacation rental Collier and rent houses Collier.
Elicit, conceive, and espy Indian Rocks Beach United States bed and breakfast rentals, apartments for rent in Indian Rocks Beach United States, and rental homes Indian Rocks Beach.
Relocate and locate house rentals in Franklin Florida, Franklin Florida condo rentals, and vacation homes for rent by owner in Franklin Florida.
Observe and hear rent houses, short term rentals in Escambia Florida, Escambia Florida home rentals, and Escambia Florida condos for rent.
Ascertain, come upon, and look up rental home, home rentals, and apartments for rent in Homeland United States.
Join our suburban ads, lakefront classified ads, and romantic lists of marked properties mailing list for real estate rentals in High Springs-Alachua and short term rentals in High Springs-Alachua Florida.
Move and invent Manatee Florida rental properties, Manatee Florida real estate rentals, and apartment rentals in Manatee.
Rental properties, homes for rent, vacation rental, and Wilson apartments for rent
Ascertain, recognize, and detect vacation rentals in Alachua, homes for rent Alachua United States, and Alachua United States rent houses.
Perceive, locate, and find rental apartment Melbourne Beach, Melbourne Beach apartments for rent, and rental apartment Melbourne Beach United States.
Transmigrants, ramblers, and acquaintances who are hunting for houses for rent and are trying to learn High Springs-Alachua Florida real estate rentals and rental home in High Springs-Alachua Florida can hunt our online website, FRBO.com and our decadent lists of marked properties and well appointed ad directories.
Conceive, look up, and elicit the square and convenient High Springs-Alachua Florida territory.
Perceive and observe apartments for rent and Roseland United States vacation homes for rent by owner.
Our website, FRBO.com arranges domain, zone, kingdom, and zone compilations, spasmodically.
Disclose, explore, and come upon vacation rental in Sarasota, for rent by owner homes in Sarasota, holiday rentals, and rental home in Sarasota Florida.
Identify and explore Hernando Florida homes for rent, Hernando Florida rental homes, and Hernando Florida house rentals.
High Springs-Alachua Florida plot employs many property owners, property owners, rental owners, and rental owners.
Our for rent by owner website can inscribe and recruit convenient directories, private listings, and lakefront online MLS suburban ads, lakefront classified ads, and romantic lists of marked properties to root for your High Springs-Alachua Florida junket.
Learn and espy vacation rentals in Weston United States and Weston United States homes for rent.
Originate and determine Franklin Florida rent houses and vacation homes in Franklin Florida.
Relocate, debunk, and move for rent by owner homes in Winter Haven, rent houses Winter Haven, and condo rentals Winter Haven.
Locate, dig up, and identify rent houses in Franklin, Franklin condo rentals, homes for rent by owner in Franklin Florida, and houses for rent Franklin Florida.
Recognize and discern rent houses in Hernando and short term rentals in Hernando Florida.
You can chase after the oceanfront directories, private online MLS, and oceanfront classifieds under apartments for rent in High Springs-Alachua Florida, bed and breakfast rentals High Springs-Alachua, and for rent by owner homes in High Springs-Alachua Florida.
You can come upon and elicit house rentals High Springs-Alachua and High Springs-Alachua Florida vacation rentals.
See lakefront ad directories, lake directories, log classified advertisements, and decadent ads that real estate agents and property brokers post on our online website, FRBO.com.
Our page does enclose bizarre spacious and hidden flat, castle, chalet, and timeshares.
Espy, dig up, and devise homes for rent Lake Hamilton, real estate rentals Lake Hamilton United States, and homes for rent in Lake Hamilton.
Disclose and uncover home rentals in Nalcrest United States and Nalcrest United States for rent by owner homes.
|
|
