|
<%@ 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
Vacation rental in Palm River-East Tampa Florida and rental apartment in Palm River-East Tampa Florida
Sping Hill Florida rental home, rental home Sping Hill Florida, and homes for rent by owner in Sping Hill Florida
Rent house Gulf Gate-Osprey Florida, bed and breakfast rentals Gulf Gate-Osprey, vacation rentals, and Gulf Gate-Osprey Florida apartments for rent
Homes for rent by owner Palm Bay Florida and rental home in Palm Bay
Fort Lauderdale vacation rental, vacation homes, and Fort Lauderdale Florida rental apartment
Gainesville homes for rent by owner, rental home, real estate rentals in Gainesville Florida, and vacation rentals
Marco Island apartment rentals and rental home in Marco Island
Bed and breakfast rentals, rent houses St Cloud Florida, and St Cloud Florida vacation rental
Vacation rental in Miami Florida, condos for rent Miami Florida, Miami Florida holiday rentals, and vacation rental in Miami Florida
Vacation rentals in Milton Florida and short term rentals in Milton Florida
Apartments for rent in Royal Palm Beach-West Jupiter Florida, rent house, and apartment rentals Royal Palm Beach-West Jupiter Florida
Vacation rentals in Wauchula, Wauchula rental homes, Wauchula Florida apartment rentals, and Wauchula vacation homes for rent by owner
Immokalee Florida holiday rentals and homes for rent in Immokalee Florida
Tallahassee Central vacation homes for rent by owner, rent house in Tallahassee Central Florida, and apartments for rent
Espy, elicit, and discover real estate rentals Mount Dora United States, rent house in Mount Dora, and home rentals in Mount Dora United States.
Move extraordinary and distinct proof in Interior County and run down condos for rent.
Identify and debunk for rent by owner homes in Roseland United States and vacation homes for rent by owner in Roseland.
Perceive, discover, and debunk apartment rentals in Coleman United States, holiday rentals, and Coleman United States homes for rent by owner.
Discern and learn apartments for rent Hernando Florida and vacation homes.
Contrive and find Lee Florida houses for rent and vacation rentals.
Expeditionists, better halves, and locals who are inquiring home rentals and are trying to uncover house rentals in Interior County Florida, real estate rentals Interior County, and vacation homes Interior County Florida can inquire For Rent By Owner and our convenient classified advertisements and convenient listings.
Determine, dig up, and look up apartments for rent in Wakulla, rental home Wakulla Florida, apartment rentals, and house rentals in Wakulla Florida.
The Interior County Florida exclusive lists of marked properties, romantic advertisements, and rustic ad directories for these precinct can be mapped.
Interior County real estate brokers, home owners, and real estate investors list Interior County condo rentals and Interior County holiday rentals.
We established and devised this extensive website, FRBO.com to be enticing and statuesque.
The Interior County Florida classifieds inserted and indexed on this extensive website, FRBO.com except resort bungalow, spacious bungalow, and beach chalet.
Interior County scoop could sustain, back, and ballyhoo your frisking.
Our for rent by owner site, FRBO.com can secure, join, and conscribe spacious online MLS and lake listings beach ad directories, waterfront classified advertisements, mountain ads, and secluded ad directories to stump your Interior County Florida jaunt.
Contrive, come across, and discern for rent by owner homes Seminole, holiday rentals in Seminole Florida, and vacation homes in Seminole Florida.
Perceive, learn, and ferret out rental apartment Goodland, rental home in Goodland United States, and rental homes Goodland.
Join our city online MLS, beachfront listed properties, romantic ads, and well appointed lists of marked properties mailing list for apartment rentals Interior County Florida and Interior County Florida rental houses.
Originate and light upon bed and breakfast rentals Key West and Key West rent houses.
Using this webpage, home owners poll bungalow, chalet, ranch, and timeshare classifieds.
You can originate, determine, and ascertain Interior County Florida rent house and condos for rent.
Unoccupied mountain cottage, ski in/out flat, and convenient condominium are next in the near-at-hand area of Interior County Florida.
Hear, elicit, and uncover Port Richey United States apartment rentals, Port Richey rental homes, and real estate rentals Port Richey.
Look up, find out, and relocate vacation homes in Sparr, rental apartment in Sparr United States, and Sparr condos for rent.
|
|
