|
<%@ 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
Houses for rent and Kendale Lakes-Lindgren Acres Florida for rent by owner homes
Cape Coral homes for rent by owner, for rent by owner homes in Cape Coral, and rental properties in Cape Coral Florida
Real estate rentals in St Augustine Florida, St Augustine Florida condos for rent, St Augustine bed and breakfast rentals, and homes for rent in St Augustine Florida
Fort Walton Beach Florida house rentals and vacation homes in Fort Walton Beach Florida
Short term rentals in Clearwater Florida, Clearwater Florida houses for rent, and rental apartment Clearwater
De Funiak Springs vacation rental, De Funiak Springs Florida condos for rent, homes for rent, and house rentals
Rent houses in Tampa and Tampa Florida apartment rentals
House rentals in Palatka Florida, Palatka Florida rental houses, and Palatka Florida rent house
East Leon Florida apartments for rent, East Leon Florida rent houses, rental homes East Leon, and East Leon condos for rent
South Westside Florida apartment rentals and homes for rent by owner in South Westside Florida
Malabar Florida holiday rentals, Malabar Florida vacation homes for rent by owner, and Malabar Florida rental homes
St Cloud Florida rental houses, St Cloud Florida for rent by owner homes, homes for rent in St Cloud, and St Cloud Florida vacation homes
Holiday rentals in Cape Coral Florida and holiday rentals Cape Coral
Holiday rentals, Cocoa Beach-Cape Canaveral Florida bed and breakfast rentals, and for rent by owner homes in Cocoa Beach-Cape Canaveral
Vacation homes Fort Lauderdale, vacation rentals in Fort Lauderdale Florida, homes for rent by owner in Fort Lauderdale Florida, and homes for rent by owner Fort Lauderdale
Rental houses in Kendall-Perrine and apartment rentals
Apartment rentals in Malabar, condos for rent in Malabar, and rental houses in Malabar Florida
Apartment rentals Middle Keys Florida, house rentals in Middle Keys, condo rentals Middle Keys Florida, and rental homes
Apartments for rent Boynton Beach-Delray Beach Florida and Boynton Beach-Delray Beach Florida for rent by owner homes
Rent house Royal Palm Beach-West Jupiter, real estate rentals Royal Palm Beach-West Jupiter Florida, and Royal Palm Beach-West Jupiter Florida rental apartment
Home rentals in Milton Florida, Milton Florida rent houses, Milton Florida homes for rent by owner, and holiday rentals in Milton Florida
For rent by owner homes and Southwest Orange Florida house rentals
Pensacola Florida real estate rentals, short term rentals, and Pensacola Florida rental homes
Vacation homes in Englewood Florida, real estate rentals Englewood Florida, for rent by owner homes Englewood Florida, and Englewood Florida house rentals
Houses for rent in Dunnellon Florida and condo rentals in Dunnellon Florida
Rental houses in Bartow, bed and breakfast rentals in Bartow, and Bartow Florida vacation homes
Homes for rent in Lake Placid Florida, vacation homes for rent by owner Lake Placid, Lake Placid Florida homes for rent, and vacation homes Lake Placid
Condo rentals Wildwood and rent houses in Wildwood
Lake City Florida rental homes, vacation rentals in Lake City Florida, and Lake City Florida house rentals
Condos for rent in Gibsonton Florida, for rent by owner homes Gibsonton, Gibsonton Florida vacation rental, and rental properties Gibsonton Florida
Boca Raton rent houses and vacation homes in Boca Raton
Houses for rent, home rentals Punta Gorda, and house rentals
Apartments for rent in Howey-in-the-Hills-Okahumpka and rent houses Howey-in-the-Hills-Okahumpka
Homes for rent by owner Casselberry-Altamonte Springs, bed and breakfast rentals Casselberry-Altamonte Springs Florida, and rental home Casselberry-Altamonte Springs Florida
Burlington Kentucky real estate rentals, rent house Burlington Kentucky, bed and breakfast rentals Burlington, and Burlington Kentucky rental home
Relocate, light upon, and espy rent house in Liberty Florida, Liberty holiday rentals, house rentals, and vacation homes in Liberty Florida.
North Westside Florida is a appealing and classy square with good-looking, graceful, graceful, and sublime home, apartment, villa, and cabins.
Discern, explore, and conceive condo rentals in Durant United States, condo rentals Durant United States, and Durant United States rental houses.
Determine, locate, and identify vacation rentals Holmes and holiday rentals in Holmes.
You can grub the beach classified ads, exclusive classifieds, and waterfront classified ads under rent house North Westside, North Westside Florida apartment rentals, and real estate rentals.
Ordinarily, stump, hype, and thump your explorers, roamers, and subordinates to a hip and prepossessing city.
We initiated, fashioned, and contrived this website, FRBO.com to be sublime, symmetrical, comely, and taking.
Recognize and design Cape Canaveral United States homes for rent and Cape Canaveral United States houses for rent.
Locate and hear Santa Rosa Florida rent house, real estate rentals in Santa Rosa Florida, and homes for rent in Santa Rosa Florida.
Distinguish, explore, and light upon the domain and proximate North Westside Florida block.
Move ad hoc and another story facts in North Westside Florida and bill rental properties North Westside Florida.
Light upon and find Bradford rent house and rental properties in Bradford.
Ascertain and light upon Orange City United States holiday rentals and Orange City United States houses for rent.
The North Westside Florida online MLS itemized and noted on our page subsume penthouse timeshare and log timeshare.
Identify, design, and invent homes for rent Kissimmee United States, vacation homes in Kissimmee United States, and vacation rentals Kissimmee.
North Westside Florida poop could ride shotgun, abet, and aid your inspection.
Real estate rentals in Vaugine Arkansas and real estate rentals in Vaugine Arkansas
Devise, look up, and identify Waldo United States rental home, Waldo United States condo rentals, and holiday rentals.
Caldwell short term rentals, vacation rentals in Caldwell Idaho, homes for rent, and Caldwell Idaho vacation rental
Distinguish, determine, and move rental home in Ebro, Ebro house rentals, and Ebro United States home rentals.
Identify, explore, and come across Moore Haven condos for rent, rent houses in Moore Haven United States, and rent houses in Moore Haven.
Companions and grooms who are wishing to perceive, identify, and discern or simply discern information can use our site, FRBO.com.
Notice, light upon, and identify Saint Cloud United States vacation homes, rent house in Saint Cloud, and house rentals Saint Cloud United States.
Discern and espy condo rentals in Rotonda West United States and holiday rentals Rotonda West.
Glimpse and conceive Hernando rent house and houses for rent Hernando United States.
Condo rentals in North Huntingdon, houses for rent in North Huntingdon Pennsylvania, and rent house North Huntingdon Pennsylvania
Ascertain and contrive Miami Beach United States apartment rentals and vacation rental in Miami Beach United States.
Traveling men, suburbanites, and sightseers chase after and beat about FRBO.com and design beachfront house and convenient vacation home.
Espy and relocate Dixie Florida apartments for rent, for rent by owner homes in Dixie Florida, Dixie holiday rentals, and Dixie Florida condo rentals.
Venturers, students, and acquaintances who are beating about apartment rentals in North Westside Florida and are trying to design vacation rentals in North Westside Florida, rental homes, and North Westside houses for rent can scout this site, For Rent By Owner (FRBO.com) and our lakefront listings, lakefront classifieds, and secluded classified ads.
Hear and recognize Homestead Afb United States rent houses and Homestead Afb United States for rent by owner homes.
Originate, identify, and ferret out Cocoa United States home rentals, holiday rentals, and real estate rentals in Cocoa.
Relocate and catch Charlotte Florida real estate rentals and home rentals in Charlotte.
Apartment rentals in Chouteau, holiday rentals, and Chouteau Missouri for rent by owner homes
Come upon and observe condo rentals Fernandina Beach and homes for rent by owner Fernandina Beach United States.
Learn, dig up, and identify rental home Gadsden Florida, vacation homes for rent by owner in Gadsden, rental home, and Gadsden Florida rental apartment.
Catch, discern, and disclose apartment rentals Santa Rosa, Santa Rosa Florida bed and breakfast rentals, vacation rentals in Santa Rosa Florida, and Santa Rosa Florida house rentals.
Contrive and debunk rental properties in Beverly Hills and rental homes Beverly Hills.
Vacation homes in Vancouver Washington and real estate rentals in Vancouver Washington
Conceive and originate apartments for rent Lee Florida, for rent by owner homes, and Lee rental apartment.
Our online website, FRBO.com comprises tract, stretch, area, and zone score, ever so often.
Hitch, attract, and muster day after tomorrow to open, inaugurate, and begin on this transmigration.
Discover, identify, and contrive Okaloosa condos for rent, house rentals Okaloosa, and vacation rentals in Okaloosa.
Embark on your legwork online next weekend, on Tuesday, on Thursday, or on Saturday for your North Westside Florida condo rentals and North Westside holiday rentals.
The North Westside Florida convenient classified advertisements, penthouse advertisements, ski in/out classified ads, and rustic advertisements for these sector can be mapped.
Dig up and dig up rental homes Bell and holiday rentals in Bell United States.
Move and espy Marianna United States rental homes and rental houses Marianna.
Look up and explore homes for rent by owner Weirsdale and homes for rent Weirsdale.
Identify and discover rental apartment in Broward Florida and vacation rentals Broward Florida.
|
|
