|
<%@ 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
Condo rentals Palm River-East Tampa and apartment rentals Palm River-East Tampa Florida
Daytona Beach Florida vacation rental, short term rentals, and rent houses Daytona Beach
Rent houses in Dade City Florida, homes for rent Dade City, Dade City homes for rent by owner, and vacation rental in Dade City
Bunnell condo rentals and house rentals in Bunnell Florida
Real estate rentals in Quincy Florida, bed and breakfast rentals in Quincy Florida, and Quincy homes for rent by owner
Matanzas Florida vacation rental, Matanzas Florida vacation homes, condo rentals Matanzas Florida, and real estate rentals
Rental home in Ruskin and Ruskin Florida rental houses
Panama City Beaches Florida rental home, Panama City Beaches Florida homes for rent, and home rentals
Princeton-Goulds Florida apartments for rent, bed and breakfast rentals in Princeton-Goulds, Princeton-Goulds Florida condo rentals, and rental apartment Princeton-Goulds Florida
Fort Walton Beach homes for rent and Fort Walton Beach Florida rent house
Rent houses in Winter Garden-Ocoee Florida, short term rentals Winter Garden-Ocoee, and Winter Garden-Ocoee Florida apartment rentals
Homes for rent in Cross City North, real estate rentals in Cross City North, Cross City North Florida apartment rentals, and Cross City North vacation homes
Dunnellon Florida homes for rent and rental homes in Dunnellon
Gibsonton Florida houses for rent, Gibsonton Florida rent house, and rental homes
Condos for rent in New Port Richey Florida, New Port Richey Florida rental houses, New Port Richey vacation homes, and rental properties in New Port Richey Florida
Rental apartment in Ponte Vedra Florida and rent house in Ponte Vedra Florida
Rental apartment in Leesburg Florida, houses for rent in Leesburg Florida, and Leesburg holiday rentals
Apartments for rent in St Cloud Florida, vacation rental St Cloud Florida, rent house in St Cloud Florida, and vacation homes for rent by owner St Cloud Florida
Homes for rent by owner in Wimauma-Lithia Florida and Wimauma-Lithia apartments for rent
Home rentals in Southwest Leon Florida, vacation homes for rent by owner in Southwest Leon Florida, and Southwest Leon Florida vacation rentals
Ruskin Florida rent houses, rental properties Ruskin, Ruskin Florida for rent by owner homes, and Ruskin Florida homes for rent
Malabar Florida holiday rentals and rental home in Malabar
Home rentals, bed and breakfast rentals, and rental properties Sanderson Florida
For rent by owner homes Chiefland, homes for rent Chiefland Florida, rent houses in Chiefland Florida, and Chiefland Florida holiday rentals
Vacation rentals in Southeast Leon Florida and Southeast Leon homes for rent
Apartment rentals, Davie rent houses, and rent houses
Lake Wales Florida rental homes, Lake Wales rental homes, Lake Wales Florida houses for rent, and Lake Wales Florida condo rentals
Rental homes in Tampa Florida and Tampa Florida rental properties
Fort Myers Florida condo rentals, rental properties in Fort Myers Florida, and for rent by owner homes in Fort Myers Florida
Homestead houses for rent, Homestead rental home, Homestead Florida rent house, and rental houses in Homestead Florida
Casselberry-Altamonte Springs Florida vacation homes for rent by owner and Casselberry-Altamonte Springs vacation rentals
Vacation homes Fort White Florida, homes for rent in Fort White Florida, and rental apartment in Fort White
Rent house and Southeast Bexar apartments for rent
Apartment rentals in New Albany, vacation homes in New Albany Indiana, and vacation rental New Albany Indiana
Rental apartment in Southwest San Gabriel Valley California and real estate rentals
Come upon and recognize vacation homes for rent by owner in Walton Florida and apartments for rent Walton Florida.
Find out, design, and find condo rentals, short term rentals in Palm City United States, and Palm City rental homes.
Hillside classifieds and mountain ads bed and breakfast rentals, vacation rental in Okaloosa Florida, homes for rent Okaloosa Florida, and real estate rentals Okaloosa Florida.
Come upon, come across, and devise Columbia Florida rental home and bed and breakfast rentals in Columbia Florida.
We organized, conceived, and designed this website, FRBO.com to be fascinating and graceful.
Dig up and originate Osprey United States vacation rentals and apartment rentals in Osprey United States.
The South Peninsula Florida classified ads indexed and enrolled on this website, FRBO.com take in secluded home, penthouse townhouse, beachfront duplex, and oceanfront castle.
Identify, design, and come across Miccosukee condo rentals, house rentals in Miccosukee United States, and home rentals in Miccosukee United States.
You can poke into the oceanfront classifieds, well appointed ads, exotic classified ads, and penthouse ads under vacation homes in South Peninsula Florida and South Peninsula Florida bed and breakfast rentals.
South Peninsula is a dazzling and pretty turf with magnificent, admirable, splendid, and cute farmhouse, duplex, timeshare, and cottages.
Debunk, originate, and learn house rentals Indian Rocks Beach, holiday rentals, and homes for rent by owner Indian Rocks Beach United States.
Espy, design, and locate rental apartment in St. Lucie, St. Lucie bed and breakfast rentals, and St. Lucie home rentals.
See rustic ads, hillside indexes, and exotic listings that rental agents and agents serving the condo market post on this webpage.
Design, identify, and dig up Santa Rosa Florida condos for rent, apartment rentals in Santa Rosa, Santa Rosa rental homes, and rental apartment in Santa Rosa Florida.
Explore and catch holiday rentals in Floral City United States and rental apartment in Floral City United States.
Our for rent by owner site, FRBO.com subsumes plot, zone, dominion, and tract details, every now and then.
Identify, ascertain, and conceive homes for rent, rent houses in Osprey United States, and Osprey United States rent house.
Design, perceive, and look up Hallandale vacation homes, home rentals Hallandale United States, and Hallandale United States for rent by owner homes.
Send stunning and charming score regarding homes for rent by owner in South Peninsula and bed and breakfast rentals in South Peninsula Florida found on our for rent by owner website.
Our for rent by owner site, FRBO.com can conscribe, secure, and list beach indexes, hidden indexes, and romantic ads studio directories, ski in/out lists of marked properties, secluded classified ads, and oceanfront advertisements to do for your South Peninsula ramble.
Soon to be vacant private duplex, suburban farmhouse, hidden cottage, and decadent apartment are contiguous in the not far city of South Peninsula.
Catch and ferret out Collier Florida for rent by owner homes, Collier Florida apartment rentals, and Collier Florida for rent by owner homes.
Using our webpage, property managers insert home, lodge, cottage, and flat ads.
Invent and ferret out Pinellas Florida apartment rentals and rental houses in Pinellas.
Find out, catch, and uncover real estate rentals Islamorada United States, Islamorada United States apartment rentals, and Islamorada United States homes for rent.
Glimpse, come across, and espy rental houses Oldsmar, houses for rent Oldsmar United States, and vacation homes for rent by owner Oldsmar.
Discover, conceive, and disclose vacation homes in Morriston United States, homes for rent in Morriston United States, and vacation homes.
Invent and uncover Keystone Heights United States bed and breakfast rentals and rent houses in Keystone Heights United States.
Dig up, come across, and observe homes for rent San Mateo, vacation homes for rent by owner San Mateo United States, and apartment rentals in San Mateo.
Rental houses in Mason, Mason homes for rent, Mason Missouri short term rentals, and Mason Missouri real estate rentals
Relocate and relocate rental apartment and Port Canaveral vacation homes for rent by owner.
South Peninsula condo owners, agents serving the condo market, property agents, and rental property owners list South Peninsula Florida homes for rent by owner, rental apartment South Peninsula Florida, and holiday rentals in South Peninsula Florida.
Determine and determine Hudson United States rental home and vacation homes Hudson United States.
|
|
