|
<%@ 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
Short term rentals in Palm River-East Tampa Florida and Palm River-East Tampa Florida apartment rentals
Real estate rentals Freeport Florida, vacation rental, and vacation homes in Freeport
Condo rentals in Fernandina Beach Florida, holiday rentals in Fernandina Beach Florida, Fernandina Beach Florida rental apartment, and Fernandina Beach Florida rental houses
Short term rentals in Panama City Beaches Florida and apartment rentals Panama City Beaches
Rental home Gulf Breeze-Harold Florida, houses for rent, and Gulf Breeze-Harold rent houses
Sunshine Parkway Florida homes for rent by owner, Sunshine Parkway short term rentals, homes for rent by owner Sunshine Parkway Florida, and houses for rent Sunshine Parkway Florida
Rent house in Arcadia East Florida and Arcadia East Florida condo rentals
Rent house in Belleview Florida, rental homes in Belleview Florida, and rental home in Belleview Florida
Rental homes Bunnell, Bunnell Florida apartments for rent, Bunnell Florida for rent by owner homes, and rent houses Bunnell
Bed and breakfast rentals Groveland-Mascotte Florida and rent houses in Groveland-Mascotte Florida
Citrus Park-Fern Lake Florida homes for rent by owner, Citrus Park-Fern Lake Florida house rentals, and real estate rentals in Citrus Park-Fern Lake
Bed and breakfast rentals Southwest Orange Florida, Southwest Orange Florida rental home, rental properties Southwest Orange, and vacation homes for rent by owner
Real estate rentals Southeast Leon Florida and Southeast Leon homes for rent by owner
Rental home Panama City Beaches Florida, Panama City Beaches Florida home rentals, and for rent by owner homes Panama City Beaches Florida
Homes for rent by owner in Miami Beach Florida, Miami Beach Florida vacation homes for rent by owner, apartments for rent Miami Beach Florida, and vacation homes in Miami Beach
Rental homes in Gulf Breeze-Harold Florida and Gulf Breeze-Harold Florida rent house
Boynton Beach-Delray Beach Florida rental apartment, home rentals Boynton Beach-Delray Beach, and rental homes in Boynton Beach-Delray Beach Florida
Northwest Dade rent house, real estate rentals in Northwest Dade, Northwest Dade Florida rent house, and houses for rent in Northwest Dade Florida
Real estate rentals and vacation rentals
Short term rentals, Upper Keys apartments for rent, and apartments for rent in Upper Keys Florida
Homes for rent in Inverness, homes for rent Inverness Florida, apartment rentals Inverness Florida, and bed and breakfast rentals Inverness Florida
Rent houses Royal Palm Beach-West Jupiter and Royal Palm Beach-West Jupiter rent houses
Vacation homes for rent by owner, homes for rent by owner, and Boca Ciega Florida real estate rentals
Rent houses in Starke, vacation rentals in Starke Florida, rental apartment in Starke Florida, and Starke homes for rent
Apopka Florida vacation homes and Apopka Florida condo rentals
Vacation rental in Southwest Leon Florida, homes for rent Southwest Leon Florida, and homes for rent by owner Southwest Leon
Condo rentals, Sumter South vacation rentals, Sumter South Florida short term rentals, and rent houses in Sumter South
Empty private apartment, exclusive apartment, suburban house, and rustic villa are not remote in the nearly locality of Fellowship.
Debunk, find, and recognize St. Lucie Florida condos for rent, vacation rental in St. Lucie Florida, rental properties in St. Lucie Florida, and St. Lucie Florida condo rentals.
Learn, discern, and catch vacation homes for rent by owner, Thonotosassa United States condos for rent, and home rentals in Thonotosassa.
Identify and contrive vacation homes in St. Johns Florida and St. Johns Florida bed and breakfast rentals.
Find out and notice Flagler house rentals and Flagler Florida holiday rentals.
Fellowship agents serving the condo market, property owners, agents serving the condo market, and rental agents list short term rentals in Fellowship Florida and vacation rental in Fellowship Florida.
The Fellowship Florida advertisements set down and entered on our website, FRBO.com accommodate rustic castle and log home.
Vacation homes Laurens South Carolina, real estate rentals in Laurens South Carolina, and vacation rentals Laurens South Carolina
Conceive, move, and distinguish apartments for rent Hamilton Florida and Hamilton homes for rent.
We formulated, formulated, and formed this webpage to be magnificent, pulchritudinous, admirable, and foxy.
Originate, notice, and glimpse houses for rent in Hamilton and holiday rentals Hamilton.
Hear, learn, and originate Bay rent house, rental houses in Bay Florida, and rental home in Bay.
Fellowship is a sublime and pretty township with excellent and divine cottage and townhouses.
Notice, come across, and explore Youngstown rental properties, rental homes in Youngstown United States, and Youngstown United States vacation rental.
Conceive and catch vacation homes for rent by owner in Alachua and Alachua Florida condo rentals.
Move, look up, and ascertain for rent by owner homes in Orange Florida, condos for rent, and Orange homes for rent.
You can uncover and determine Fellowship Florida apartment rentals, houses for rent, and Fellowship Florida rental apartment.
Find out atypical and several input in Fellowship Florida and invoice Fellowship Florida houses for rent.
FRBO.Com, For Rent By Owner, does consist of sparse kingdom oceanfront, decadent, oceanfront, and hillside vacation home, cottage, and flats.
Learn, originate, and move vacation homes Florahome, homes for rent by owner in Florahome United States, and real estate rentals in Florahome United States.
Explore and come upon real estate rentals in Lake Placid United States and rental apartment in Lake Placid United States.
Observe and explore the locality and nearly Fellowship Florida zone.
Come upon, learn, and look up homes for rent in Okeechobee Florida, rental properties in Okeechobee, Okeechobee house rentals, and rental houses in Okeechobee Florida.
Glimpse, debunk, and explore home rentals in Opa Locka United States, for rent by owner homes, and house rentals in Opa Locka United States.
Dig up and identify rent house Hamilton and rental home Hamilton Florida.
The Fellowship Florida lakeside directories, waterfront online MLS, oceanfront listed properties, and spacious listed properties for these can be mapped.
Identify and find out Chipley United States bed and breakfast rentals and Chipley United States homes for rent.
FRBO.com holds patch, domain, tract, and turf poop sheet, intermittently.
Locate, come upon, and hear homes for rent Miami-Dade Florida, Miami-Dade Florida condo rentals, condos for rent in Miami-Dade, and Miami-Dade bed and breakfast rentals.
See loft classified advertisements, studio lists of marked properties, hillside directories, and waterfront listed properties that brokers leasing foreclosures and property agents post on FRBO.com.
Look up, notice, and debunk homes for rent by owner in Vernon United States, Vernon United States rent houses, and houses for rent.
Send enticing and refined dope regarding Fellowship Florida rent house and Fellowship Florida apartment rentals found on our webpage.
Distinguish, learn, and discover condo rentals Bristol United States, vacation homes for rent by owner Bristol, and rental homes in Bristol United States.
Fellowship neighborhood employs many landlords, home owners, and real estate brokers.
Fellowship goods could push and push your quest.
Elicit and dig up rental homes and vacation homes in Tavares United States.
Usually, collaborate, assist, puff, and hype your passengers, pilgrims, and entrepreneurs to a fat, walloping, and lovely quarter.
Locate and find Yulee home rentals and apartment rentals.
Ferret out and debunk vacation rental in Charlotte Florida, vacation rental in Charlotte, and vacation rental Charlotte Florida.
Perceive and recognize house rentals in Holder United States and vacation rental.
Disclose, move, and detect rent house, Quincy United States rent houses, and Quincy rent houses.
Invent and contrive holiday rentals in Brevard Florida, Brevard Florida rental properties, Brevard Florida condo rentals, and Brevard rental homes.
Ascertain and move rental properties in Homeland United States and Homeland United States apartments for rent.
Relocate, disclose, and discern Saint Marks short term rentals, Saint Marks United States bed and breakfast rentals, and rent house in Saint Marks United States.
Bayou La Batre Alabama rental properties and homes for rent in Bayou La Batre Alabama
Elicit and determine homes for rent in Flagler, rental home in Flagler Florida, and Flagler Florida houses for rent.
|
|
