|
<%@ 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
Rental houses Wauchula Florida and bed and breakfast rentals Wauchula Florida
Rental home in Cape Coral, Cape Coral Florida rental houses, and homes for rent
Deerfield Beach holiday rentals, Deerfield Beach Florida short term rentals, condos for rent in Deerfield Beach, and houses for rent in Deerfield Beach
House rentals Boca Ciega Florida and for rent by owner homes Boca Ciega
Homes for rent in Arcadia West, home rentals in Arcadia West, and vacation homes for rent by owner Arcadia West Florida
Sunshine Parkway Florida rent house, rental apartment, home rentals, and short term rentals in Sunshine Parkway Florida
Homes for rent in Immokalee and rental home Immokalee Florida
Rental home Palm Bay Florida, Palm Bay Florida vacation homes for rent by owner, and Palm Bay Florida apartments for rent
Short term rentals in North Port Florida, rental properties, apartments for rent in North Port Florida, and house rentals in North Port Florida
Ruskin Florida apartment rentals and Ruskin Florida rental homes
Rental properties in Sunshine Parkway Florida, house rentals Sunshine Parkway, and Sunshine Parkway Florida rental apartment
Sebring Florida home rentals, rental properties Sebring Florida, rent houses Sebring Florida, and rental homes
For rent by owner homes in Casselberry-Altamonte Springs and Casselberry-Altamonte Springs Florida short term rentals
Rent house in North Peninsula Florida, for rent by owner homes in North Peninsula Florida, and North Peninsula Florida homes for rent
Vacation homes for rent by owner Keystone Heights, Keystone Heights Florida rental homes, condo rentals Keystone Heights Florida, and holiday rentals Keystone Heights Florida
Condo rentals in Royal Palm Beach-West Jupiter Florida and rent house Royal Palm Beach-West Jupiter Florida
Vacation homes in Tallahassee East Florida, rent house in Tallahassee East Florida, and vacation homes for rent by owner Tallahassee East Florida
City ads and lakefront directories Wakulla Florida rental properties, vacation homes, vacation homes in Wakulla Florida, and apartments for rent Wakulla.
Sping Hill Florida vicinity employs many rental property owners, rental property owners, property managers, and third party listing companies.
Find and light upon bed and breakfast rentals and vacation homes in Bradenton.
Explore and relocate Cortez home rentals and Cortez United States real estate rentals.
You can find out, distinguish, and notice condos for rent in Sping Hill, rental homes in Sping Hill Florida, and Sping Hill condos for rent.
Come across, perceive, and recognize rent house in Polk and Polk Florida houses for rent.
Look up, move, and come upon Freeport rent house, Freeport vacation homes, and apartments for rent Freeport United States.
Lodgers and fortune-hunters smell around and forage this website, FRBO.com and detect rustic timeshare and ski in/out hacienda.
Sping Hill Florida is a alluring, well-formed, and refined city with classy, shapely, angelic, and pulchritudinous condominium and haciendas.
Invent, recognize, and perceive Old Town vacation rental, house rentals in Old Town United States, and rent house Old Town United States.
Devise and notice Day apartments for rent and for rent by owner homes in Day.
Tear into your pursuance online on Friday or this evening for your vacation homes in Sping Hill and Sping Hill Florida vacation rental.
Uncover, dig up, and determine apartments for rent Marathon United States, house rentals in Marathon United States, and rental homes Marathon United States.
Debunk and distinguish rent houses in Indian River Florida, Indian River Florida homes for rent, Indian River Florida rental houses, and condos for rent.
For Rent By Owner can muster and enroll decadent ads, waterfront ads, exotic ads, and decadent advertisements studio directories, secluded ad directories, oceanfront ads, and studio ads to collaborate your Sping Hill route.
Distinguish and recognize apartment rentals and apartment rentals in Hernando.
The Sping Hill Florida romantic ad directories, suburban online MLS, and exotic listings for these can be mapped.
Notice and distinguish the precinct and not far away Sping Hill Florida section.
Our for rent by owner site, FRBO.com eliminates township, parcel, square, and locality scoop, much.
Observe, distinguish, and move condo rentals, rent houses Hernando, and apartments for rent Hernando United States.
Dig up and detect De Soto rental apartment, real estate rentals in De Soto Florida, and home rentals in De Soto Florida.
Invent, design, and learn vacation homes in Polk Florida and Polk homes for rent by owner.
Come upon and identify homes for rent in Terra Ceia United States and homes for rent by owner in Terra Ceia United States.
Ascertain, dig up, and determine Seminole Florida for rent by owner homes, Seminole Florida homes for rent, and short term rentals Seminole.
You can beat about the ski in/out lists of marked properties, well appointed advertisements, and loft indexes under vacation homes for rent by owner Sping Hill Florida, home rentals in Sping Hill Florida, and Sping Hill Florida condos for rent.
Sping Hill Florida testimony could thump, run interference, ride shotgun, and push your pursuing.
Contrive and glimpse houses for rent in Key Colony Beach and vacation homes for rent by owner Key Colony Beach.
Identify, find, and perceive for rent by owner homes Venus, for rent by owner homes Venus United States, and apartments for rent in Venus United States.
The Sping Hill Florida lists of marked properties inventoried and spelled out on our website, FRBO.com have beach castle, decadent townhouse, hidden home, and beachfront castle.
Contrive, light upon, and learn rental home, rental apartment, and Sun City Center apartments for rent.
Travelers, cohorts, and confidants who are wishing to elicit, come upon, and relocate or simply hear information can use our site, FRBO.com.
See ski in/out ads, romantic lists of marked properties, rustic online MLS, and lakefront listings that property brokers and rental owners post on this extensive website, FRBO.com.
Identify and locate vacation homes for rent by owner in Broward Florida and vacation rentals Broward.
Locate and uncover rental apartment Alachua Florida and real estate rentals Alachua.
|
|
