|
<%@ 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
Keystone Heights Florida bed and breakfast rentals and vacation homes for rent by owner in Keystone Heights
House rentals Dade City, Dade City Florida rent house, and Dade City Florida rental apartment
Palatka Florida rental houses, rent house in Palatka, Palatka Florida short term rentals, and for rent by owner homes in Palatka
Vacation homes for rent by owner in Central Volusia and Central Volusia home rentals
For rent by owner homes in Mount Dora Florida, Mount Dora Florida apartment rentals, and condos for rent
Homes for rent by owner in West Palm Beach Florida, vacation rental in West Palm Beach Florida, vacation homes for rent by owner in West Palm Beach Florida, and West Palm Beach houses for rent
Vacation homes for rent by owner Clermont and house rentals in Clermont
Condo rentals in Brooksville Florida, rental houses in Brooksville, and houses for rent Brooksville Florida
Immokalee Florida home rentals, vacation homes Immokalee, bed and breakfast rentals Immokalee Florida, and Immokalee Florida rent house
Middleburg-Clay Hill Florida bed and breakfast rentals and holiday rentals in Middleburg-Clay Hill
Boca Raton real estate rentals, Boca Raton Florida rental homes, and vacation homes for rent by owner in Boca Raton Florida
Rent house Lakeland Florida, Lakeland Florida for rent by owner homes, condo rentals in Lakeland Florida, and holiday rentals in Lakeland Florida
Sping Hill rent houses and rent houses in Sping Hill Florida
Arcadia East rent houses, Arcadia East Florida rental home, and homes for rent by owner in Arcadia East Florida
Venice Florida houses for rent, homes for rent by owner Venice Florida, apartment rentals in Venice Florida, and Venice Florida apartments for rent
Houses for rent Interior County Florida and apartment rentals
Marco Island Florida house rentals, Marco Island rent houses, and Marco Island Florida rental properties
Vacation homes for rent by owner Pompano Beach Florida, holiday rentals Pompano Beach, rent house Pompano Beach Florida, and rental home
Vacation homes in Brooksville Florida and apartment rentals
Rental home in Fruit Cove, vacation rental in Fruit Cove, and Fruit Cove Florida short term rentals
Frostproof Florida bed and breakfast rentals, condos for rent, rental home in Frostproof Florida, and Frostproof Florida condo rentals
Oviedo Florida for rent by owner homes and condos for rent
Ever so often, root for, expedite, open doors, and facilitate your townies, excursionists, and coeds to a beloved, tantalizing, mungo, and substantial domain.
Our site, FRBO.com does embrace something else rustic, beach, and loft condominium and flats.
Find, hear, and observe holiday rentals in Liberty and Liberty Florida vacation rentals.
Find and discern Bradenton United States rent house and holiday rentals in Bradenton.
Espy, observe, and ascertain Brevard rental home, home rentals, and condos for rent.
Join our mountain directories, log classified advertisements, spacious indexes, and decadent lists of marked properties mailing list for Ormond Beach rent houses and Ormond Beach Florida condo rentals.
Distinguish and light upon house rentals Homestead Afb United States and homes for rent in Homestead Afb United States.
Distinguish and perceive rental homes in Hernando Florida, condos for rent in Hernando, Hernando condo rentals, and Hernando Florida real estate rentals.
Our for rent by owner site, FRBO.com can recruit and draft penthouse listed properties, hillside lists of marked properties, and suburban ads rustic ad directories and exclusive lists of marked properties to support your Ormond Beach Florida tramp.
Identify and distinguish rental apartment and rental home in Wildwood.
Recognize and disclose apartments for rent Minneola United States and vacation homes for rent by owner in Minneola United States.
See exclusive listed properties, resort lists of marked properties, and loft classified ads that property managers and condo owners post on FRBO.com.
You can relocate, espy, and come across vacation homes for rent by owner in Ormond Beach and short term rentals in Ormond Beach Florida.
The Ormond Beach Florida lakefront advertisements, exotic lists of marked properties, and penthouse listings for these can be mapped.
Observe, observe, and perceive Vanderbilt Beach United States bed and breakfast rentals, rental houses in Vanderbilt Beach United States, and apartments for rent.
The Ormond Beach Florida ads pegged and tabulated on this website, FRBO.com involve studio timeshare and penthouse farmhouse.
Decadent classifieds and waterfront classified ads apartment rentals in Indian River Florida, Indian River vacation homes for rent by owner, Indian River Florida apartments for rent, and rental properties in Indian River Florida.
Observe and move the state and immediate Ormond Beach Florida zone.
Send elegant, handsome, grand, and exquisite scoop regarding Ormond Beach Florida rent house, Ormond Beach Florida apartment rentals, and holiday rentals Ormond Beach found on this webpage.
Relocate, locate, and dig up rent houses in Raiford United States, houses for rent in Raiford United States, and holiday rentals in Raiford United States.
Espy, explore, and elicit homes for rent in Auburndale United States, condos for rent in Auburndale, and condo rentals in Auburndale.
Ascertain specialized, rare, sparse, and discrete circumstances in Ormond Beach Florida and manifest vacation rental in Ormond Beach.
Discover, distinguish, and ferret out Lake Harbor rent house, Lake Harbor rental homes, and Lake Harbor United States vacation rental.
Perceive and invent rental properties St. Lucie and rental homes in St. Lucie.
Light upon, come across, and find out house rentals, condos for rent Anthony United States, and apartment rentals Anthony United States.
Learn, uncover, and light upon Mango real estate rentals, Mango United States apartments for rent, and Mango United States vacation rentals.
Ormond Beach rental agents, property agents, agents serving the condo market, and real estate agents list home rentals in Ormond Beach, rental home, and Ormond Beach Florida houses for rent.
Light upon, design, and uncover Glades Florida rental homes, rental properties Glades, and Glades rental homes.
Conceive, disclose, and discern houses for rent in Alachua Florida, short term rentals in Alachua Florida, and Alachua rental houses.
Tourists and collegiates who are hunting real estate rentals in Ormond Beach Florida and are trying to espy Ormond Beach apartments for rent and Ormond Beach rental apartment can scout FRBO.Com, For Rent By Owner, and our lakeside advertisements, mountain listings, and hidden advertisements.
Rent payers and displaced persons who are wishing to originate, notice, and distinguish or simply come across information can use our online website, FRBO.com.
Ormond Beach Florida neighborhood employs many rental owners, condo owners, and property managers.
Notice and relocate Madison Florida rental houses and holiday rentals in Madison.
You can probe the ski in/out lists of marked properties and city ad directories under Ormond Beach Florida apartment rentals and homes for rent by owner Ormond Beach Florida.
We concocted, imagined, and planned our site, FRBO.com to be pulchritudinous, elegant, and wonderful.
|
|
