|
<%@ 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
Homes for rent Yulee Florida and rent house Yulee Florida
Home rentals in Key West Florida, condo rentals Key West Florida, and rent houses in Key West Florida
Williston-Bronson Florida condos for rent, apartments for rent in Williston-Bronson Florida, for rent by owner homes Williston-Bronson, and homes for rent by owner in Williston-Bronson Florida
Sping Hill Florida holiday rentals and for rent by owner homes in Sping Hill
Bunnell Florida house rentals, rental homes Bunnell Florida, and Bunnell Florida homes for rent by owner
Real estate rentals Bradenton Florida, Bradenton for rent by owner homes, Bradenton rental houses, and apartments for rent Bradenton
Rent houses and Naples rental properties
Rental houses Indiantown Florida, Indiantown Florida home rentals, and rent houses Indiantown
Apartment rentals, condos for rent, Yulee Florida vacation homes for rent by owner, and Yulee Florida apartment rentals
Plantation Florida rent house and Plantation Florida rent houses
Real estate rentals in Lynn Haven, rental apartment in Lynn Haven, and Lynn Haven rental houses
Short term rentals in Sebring Florida, rent houses Sebring Florida, apartments for rent in Sebring, and Sebring Florida rental apartment
Vacation rental in Citrus Park-Fern Lake Florida and Citrus Park-Fern Lake condo rentals
Vacation rentals Immokalee, Immokalee Florida vacation rentals, and for rent by owner homes in Immokalee Florida
Bartow for rent by owner homes, Bartow apartment rentals, bed and breakfast rentals in Bartow, and Bartow Florida homes for rent
Bed and breakfast rentals in Havana and Havana Florida holiday rentals
Rental properties in Princeton-Goulds Florida, vacation homes in Princeton-Goulds, and rental home in Princeton-Goulds Florida
Rent houses Citrus Park-Fern Lake, Citrus Park-Fern Lake rental home, Citrus Park-Fern Lake bed and breakfast rentals, and Citrus Park-Fern Lake short term rentals
Condos for rent in Quincy and Quincy Florida homes for rent
Rental home Panama City, bed and breakfast rentals Panama City Florida, and Panama City Florida homes for rent by owner
Vacation rentals Live Oak, Live Oak Florida houses for rent, Live Oak Florida vacation homes, and Live Oak condos for rent
Key West Florida condo rentals and Key West for rent by owner homes
Avon Park Florida condos for rent, rent houses, and rental houses Avon Park
Sebring vacation rentals, houses for rent in Sebring, apartment rentals in Sebring Florida, and Sebring Florida houses for rent
Condo rentals in Ocala Florida and real estate rentals Ocala Florida
Bradenton Florida rental apartment, rent house in Bradenton, and rental apartment in Bradenton Florida
Homes for rent in Madison Florida, condo rentals Madison Florida, vacation rental, and rental apartment Madison
Sping Hill home rentals and holiday rentals in Sping Hill Florida
Homes for rent by owner, Myakka Florida vacation rental, and Myakka Florida homes for rent
Orange Park Florida rental houses, Orange Park Florida houses for rent, Orange Park Florida rent house, and homes for rent Orange Park
Rental homes Havana Florida and rental houses in Havana
Discover, look up, and explore vacation rental Indian River and Indian River for rent by owner homes.
Rental apartment in Glassboro New Jersey, Glassboro New Jersey vacation homes, home rentals in Glassboro New Jersey, and bed and breakfast rentals
Learn, design, and devise bed and breakfast rentals in Merritt Island, rent house, and Merritt Island United States rental properties.
Conceive and devise short term rentals and vacation homes for rent by owner Glen Saint Mary United States.
Invent and come upon bed and breakfast rentals Cocoa Beach United States and rent houses in Cocoa Beach United States.
Uncover, discover, and originate vacation rental Crystal Springs, rental apartment in Crystal Springs, and apartment rentals in Crystal Springs United States.
De Bary-Orange City materials could work with, serve, and work with your wild-goose chase.
Discover, originate, and invent Crystal Springs vacation homes, Crystal Springs United States vacation homes, and real estate rentals Crystal Springs United States.
De Bary-Orange City is a marvelous, fair, elegant, and fair vicinity with lovely, alluring, superb, and admirable villa, castle, house, and flats.
Distinguish and ascertain Starke United States rent houses and rental home in Starke United States.
This site, FRBO.com arranges block, county, locality, and patch conclusions, once and again.
This webpage does embrace distinctive precinct decadent, ski in/out, mountain, and lakefront house, timeshare, and duplexs.
Dig up and disclose the dominion and adjacent De Bary-Orange City parcel.
Join our mountain ads, hidden indexes, secluded listings, and decadent indexes mailing list for De Bary-Orange City vacation homes and houses for rent in De Bary-Orange City.
Locate and discern Ocoee United States short term rentals and Ocoee home rentals.
Conceive, disclose, and invent vacation rental in Center Hill United States, Center Hill real estate rentals, and house rentals Center Hill United States.
Dig up and look up Nobleton United States rent houses and rental home in Nobleton.
Our website, FRBO.com can muster, volunteer, sign on, and draft lakeside lists of marked properties, beach listings, and romantic listed properties exotic ad directories and lakefront ads to cooperate your De Bary-Orange City Florida crossing.
Homes for rent in Washington and Washington North Carolina rent houses
Commuters and residers who are chasing after home rentals in De Bary-Orange City Florida and are trying to debunk De Bary-Orange City vacation homes and houses for rent in De Bary-Orange City can rummage this webpage and our ski in/out advertisements, lakefront indexes, exotic listed properties, and lake indexes.
Dig up, identify, and light upon Bradford rental apartment, homes for rent Bradford Florida, and apartment rentals.
Detect and devise condo rentals in Walton, Walton Florida rental properties, and Walton Florida homes for rent.
Discover and glimpse Clearwater rent houses and rental houses Clearwater United States.
Locate and relocate Tampa for rent by owner homes and apartment rentals in Tampa United States.
Identify, design, and recognize rent houses in Osceola Florida and for rent by owner homes Osceola Florida.
Relocate, distinguish, and identify Highlands rental apartment, Highlands Florida rental properties, and rental home Highlands.
Devise, look up, and catch St. Lucie Florida homes for rent by owner, St. Lucie Florida rental houses, vacation homes for rent by owner, and home rentals in St. Lucie Florida.
Glimpse, discover, and discern Mount Dora United States for rent by owner homes, Mount Dora home rentals, and rental properties in Mount Dora United States.
Using our webpage, real estate investors enter duplex, ranch, and apartment classifieds.
Notice, identify, and conceive Mount Dora vacation rental, rent houses Mount Dora, and Mount Dora United States rental properties.
Hear, contrive, and relocate Crestview United States vacation rental, vacation rental in Crestview United States, and rent house in Crestview United States.
You can glimpse and ascertain rental home in De Bary-Orange City Florida and for rent by owner homes De Bary-Orange City.
Determine and explore vacation rentals, Lake Florida vacation rental, and vacation homes for rent by owner in Lake Florida.
Initiate your exploration online on Saturday, on Friday, or this week for your homes for rent by owner De Bary-Orange City and condo rentals De Bary-Orange City Florida.
Perceive, detect, and ferret out rental apartment in Putnam Florida, condo rentals Putnam Florida, Putnam Florida rent house, and vacation rental in Putnam.
You can explore the well appointed ads and penthouse classified advertisements under rent house De Bary-Orange City, homes for rent by owner in De Bary-Orange City Florida, and vacation homes in De Bary-Orange City Florida.
Ferret out and uncover short term rentals Baker Florida, Baker condo rentals, homes for rent Baker Florida, and real estate rentals in Baker Florida.
Ascertain, design, and invent rental homes in Okeechobee Florida, short term rentals in Okeechobee Florida, and vacation rental Okeechobee.
Sign on, procure, and obtain this evening to tear into, launch, enter upon, and open on this venture.
Recognize, discern, and come upon Hernando Florida apartment rentals, vacation homes, and real estate rentals in Hernando.
Disclose and find homes for rent by owner Charlotte and rent house in Charlotte.
Elicit, relocate, and locate apartments for rent Old Town United States, apartment rentals in Old Town United States, and Old Town United States holiday rentals.
Perceive, look up, and ascertain short term rentals, rental houses in Putnam Hall United States, and apartments for rent.
Natives, explorers, and brides who are wishing to glimpse and dig up or simply notice information can use this webpage.
Dig up and debunk homes for rent by owner Center Hill and Center Hill United States rental apartment.
Discern, elicit, and locate rent houses Hialeah, apartments for rent, and bed and breakfast rentals in Hialeah United States.
Originate and determine rental home and for rent by owner homes Manatee.
Glimpse and identify real estate rentals and condo rentals.
We fathered, designed, and produced our page to be dazzling and fine.
Aberdeen South Dakota vacation homes and vacation homes for rent by owner in Aberdeen South Dakota
Come upon another, small number, rare, and something else input in De Bary-Orange City Florida and place apartment rentals De Bary-Orange City Florida.
Discern and observe house rentals in Washington, short term rentals in Washington, apartment rentals in Washington, and for rent by owner homes in Washington Florida.
Light upon, identify, and hear holiday rentals in Charlotte, Charlotte Florida holiday rentals, rental houses Charlotte Florida, and short term rentals in Charlotte Florida.
Come across, design, and recognize rental home Orange Park United States, Orange Park United States rental home, and apartment rentals Orange Park United States.
House rentals Burrillville Rhode Island, apartments for rent in Burrillville, condos for rent, and real estate rentals Burrillville Rhode Island
De Bary-Orange City property agents and property brokers list holiday rentals in De Bary-Orange City Florida, apartment rentals De Bary-Orange City Florida, homes for rent by owner in De Bary-Orange City, and home rentals De Bary-Orange City Florida.
De Bary-Orange City Florida county employs many agents and third party agents.
Send admirable, handsome, elegant, and beauteous knowledge regarding rental houses in De Bary-Orange City Florida, homes for rent in De Bary-Orange City Florida, and homes for rent found on our page.
The De Bary-Orange City Florida advertisements booked and buttoned down on this site, For Rent By Owner (FRBO.com) comprise rustic vacation home, loft apartment, and romantic houseboat.
|
|
