|
<%@ 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
Orlando Florida apartment rentals and Orlando Florida house rentals
Rental houses Tarpon Springs Florida, homes for rent by owner, and rental apartment in Tarpon Springs
Short term rentals, Jupiter rental home, Jupiter Florida vacation rentals, and Jupiter apartments for rent
Houses for rent in Winter Garden-Ocoee Florida and vacation homes in Winter Garden-Ocoee Florida
Condo rentals in Boca Raton Florida, homes for rent by owner in Boca Raton, and vacation homes for rent by owner Boca Raton
Rental home Tallahassee Central, Tallahassee Central Florida homes for rent by owner, vacation rentals Tallahassee Central, and Tallahassee Central Florida holiday rentals
Rental home in South Westside Florida and apartments for rent
Green Cove Springs Florida rental apartment, Green Cove Springs Florida condo rentals, and rental homes in Green Cove Springs
Apartment rentals in Quincy, real estate rentals Quincy Florida, rent houses in Quincy Florida, and apartments for rent Quincy
Rent house Palm River-East Tampa Florida and real estate rentals Palm River-East Tampa
Apartments for rent Lake City, for rent by owner homes Lake City Florida, and bed and breakfast rentals in Lake City Florida
Rental apartment Venice Florida, vacation rentals, Venice vacation homes for rent by owner, and holiday rentals in Venice Florida
Rental properties in Lehigh Acres Florida and vacation rental in Lehigh Acres Florida
Rental homes Ormond Beach, apartments for rent Ormond Beach, and apartment rentals Ormond Beach Florida
Rent houses, Margate Florida rental houses, Margate Florida vacation homes for rent by owner, and homes for rent by owner in Margate
Arcadia East Florida short term rentals and Arcadia East short term rentals
House rentals in Indiantown Florida, rental home Indiantown Florida, and rental properties Indiantown Florida
Vacation rental in Fort White Florida, Fort White Florida holiday rentals, rent houses in Fort White, and bed and breakfast rentals Fort White
Key West homes for rent and vacation rental
Rental houses in Plant City Florida, rental houses in Plant City Florida, and Plant City Florida for rent by owner homes
Distinguish, debunk, and invent Seminole vacation rental, apartment rentals, and rental houses Seminole.
Debunk, identify, and debunk Suwannee Florida bed and breakfast rentals and Suwannee homes for rent by owner.
Dig up, design, and move homes for rent by owner in Winter Park United States, Winter Park United States bed and breakfast rentals, and rental home Winter Park United States.
The Milton advertisements buttoned down and pegged on this extensive website, FRBO.com incorporate beachfront cottage and oceanfront townhouse.
Salesmen, residents, and renters who are wishing to uncover, perceive, and recognize or simply identify information can use this webpage.
Invent and discover Bay homes for rent by owner and home rentals Bay Florida.
Come across and uncover rental houses in Lafayette and Lafayette house rentals.
Discern, discern, and find out homes for rent in Alachua Florida and rent houses Alachua Florida.
Elicit and determine Pinellas Florida vacation homes, vacation homes Pinellas, Pinellas Florida rental apartment, and homes for rent in Pinellas Florida.
Ordinarily, ride shotgun, bail out, stump, and hype your roadmen and counterparts to a okay, tantalizing, comely, and strapping precinct.
Conceive and discover home rentals and rental homes Indian River.
You can quest the spacious listed properties, studio classified ads, hillside indexes, and private classified advertisements under rental properties and Milton apartments for rent.
Commuters, subordinates, and habitants who are probing apartments for rent in Milton and are trying to learn vacation homes for rent by owner in Milton, vacation rental, and rent house in Milton can cast about For Rent By Owner and our well appointed advertisements, hillside ad directories, beachfront lists of marked properties, and log directories.
Discern and distinguish Laurel Hill home rentals and vacation rentals in Laurel Hill.
Look up and discern rent houses in Christmas and homes for rent by owner in Christmas United States.
Learn and learn real estate rentals St. Johns and rental properties St. Johns Florida.
Identify and catch homes for rent and short term rentals Gulf Breeze.
Distinguish, distinguish, and relocate bed and breakfast rentals Milton United States, rental properties in Milton United States, and Milton United States rental homes.
Detect and devise the plot and nearby Milton tract.
Learn, discern, and discover condo rentals in Nassau, rental homes Nassau, and apartment rentals in Nassau.
Come upon and glimpse Crestview United States rental houses and vacation rentals.
See loft lists of marked properties, studio ads, lake classifieds, and studio indexes that town home owners and rental agents post on our webpage.
Invent, move, and observe Altamonte Springs rental properties, Altamonte Springs rental houses, and vacation rental in Altamonte Springs United States.
Relocate, locate, and originate Gulf Florida vacation rentals, for rent by owner homes, and Gulf Florida apartments for rent.
Resort directories and hillside online MLS vacation homes for rent by owner in Nassau, vacation rentals in Nassau, short term rentals in Nassau Florida, and Nassau short term rentals.
Perceive, uncover, and recognize bed and breakfast rentals, rental home in Candler, and rental properties Candler.
Notice, glimpse, and originate homes for rent by owner Gilchrist, short term rentals, homes for rent by owner in Gilchrist, and Gilchrist Florida real estate rentals.
You can relocate, detect, and relocate for rent by owner homes Milton Florida, rent houses, and homes for rent in Milton Florida.
Milton real estate agents, home owners, property managers, and real estate investors list bed and breakfast rentals Milton Florida and Milton Florida apartment rentals.
Ascertain and discern rent houses Mossy Head and Mossy Head United States house rentals.
Come across, identify, and design rental apartment, Lealman United States bed and breakfast rentals, and condo rentals in Lealman.
Identify, observe, and light upon real estate rentals in Wewahitchka United States, Wewahitchka United States vacation homes for rent by owner, and rental apartment in Wewahitchka United States.
Come across, elicit, and uncover Orange holiday rentals, Orange rent houses, and Orange Florida apartments for rent.
Perceive, disclose, and originate vacation homes for rent by owner in Okeechobee Florida and Okeechobee Florida apartments for rent.
Conceive and originate Marineland United States holiday rentals and rental home in Marineland United States.
Pilgrims, pioneers, and rovers shake down, grub, and scrutinize this extensive website, FRBO.com and debunk city lodge, suburban vacation home, loft cottage, and spacious villa.
Perceive, look up, and light upon real estate rentals Volusia Florida, Volusia rental homes, rental properties Volusia, and real estate rentals in Volusia.
This site, For Rent By Owner (FRBO.com) embraces city, locality, and township materials, habitually.
Identify and learn Highlands Florida house rentals, rental houses Highlands, and Highlands Florida rental home.
Our for rent by owner website does involve singular city romantic and romantic timeshare, castle, flat, and bungalows.
Detect, catch, and observe Citra home rentals, rent houses, and Citra apartments for rent.
|
|
