|
<%@ 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
Wimauma-Lithia vacation rentals and Wimauma-Lithia Florida rental properties
Real estate rentals, home rentals Interior County Florida, and homes for rent in Interior County
Fort Walton Beach apartment rentals, apartment rentals in Fort Walton Beach Florida, houses for rent Fort Walton Beach, and apartments for rent Fort Walton Beach Florida
House rentals Jupiter and Jupiter Florida apartments for rent
Vacation rental in Northwest Dade Florida, houses for rent Northwest Dade, and vacation homes for rent by owner
Vacation homes for rent by owner Arcadia East Florida, for rent by owner homes in Arcadia East Florida, houses for rent Arcadia East Florida, and Arcadia East Florida rent houses
Houses for rent in Tallahassee Southwest Florida and Tallahassee Southwest Florida apartment rentals
Rental home in Lakeland, rental homes Lakeland, and apartment rentals Lakeland
Southeast Leon Florida rental homes, rental apartment, homes for rent by owner in Southeast Leon Florida, and rental houses
Short term rentals in Fort Myers Shores and house rentals Fort Myers Shores Florida
Gainesville condos for rent, apartment rentals in Gainesville Florida, and Gainesville Florida home rentals
Real estate rentals Merritt Island Florida, vacation rental in Merritt Island Florida, condos for rent Merritt Island Florida, and home rentals Merritt Island Florida
Rent house in Groveland-Mascotte Florida and home rentals
Brandon Florida real estate rentals, bed and breakfast rentals in Brandon Florida, and rent houses Brandon Florida
Ruskin Florida vacation homes for rent by owner, real estate rentals in Ruskin Florida, vacation homes in Ruskin Florida, and vacation rental in Ruskin Florida
Rent houses in Frostproof Florida and rental home Frostproof
Malabar Florida rental home, Malabar bed and breakfast rentals, and Malabar Florida condos for rent
Rental houses North Peninsula, for rent by owner homes North Peninsula Florida, holiday rentals in North Peninsula Florida, and holiday rentals in North Peninsula Florida
Rent house in Casselberry-Altamonte Springs and apartments for rent in Casselberry-Altamonte Springs
Sebring short term rentals, Sebring Florida bed and breakfast rentals, and Sebring Florida short term rentals
Pensacola vacation rentals, homes for rent Pensacola Florida, short term rentals in Pensacola, and Pensacola Florida homes for rent by owner
Holiday rentals Freeport and homes for rent in Freeport Florida
Rental houses in Madison Florida, home rentals in Madison Florida, and short term rentals Madison
Panama City Beaches Florida condo rentals, Panama City Beaches Florida homes for rent, Panama City Beaches house rentals, and Panama City Beaches home rentals
Homes for rent in Naples Florida and rental homes in Naples Florida
Short term rentals in Winter Garden-Ocoee Florida, Winter Garden-Ocoee Florida homes for rent by owner, and home rentals
Rental apartment in Key West Florida, rental homes Key West Florida, rental houses, and vacation homes for rent by owner
Winter Garden-Ocoee Florida rental homes and house rentals
Houses for rent in Leesburg East, bed and breakfast rentals in Leesburg East Florida, and bed and breakfast rentals Leesburg East
Holiday rentals in Umatilla Florida, vacation rentals in Umatilla Florida, Umatilla Florida short term rentals, and holiday rentals Umatilla Florida
Relocate and move Gadsden Florida short term rentals, Gadsden condo rentals, and Gadsden Florida rental houses.
See beach lists of marked properties and log classifieds that rental property owners and real estate investors post on our website, FRBO.com.
Suburbanites, professors, and acquaintances who are ransacking condos for rent and are trying to recognize homes for rent De Land Florida, De Land rental home, and houses for rent De Land can go through our for rent by owner site, FRBO.com and our convenient online MLS, studio ads, log listings, and studio online MLS.
The De Land Florida online MLS numerated and specialized on this extensive website, FRBO.com involve studio cottage, lake house, and oceanfront bungalow.
The De Land studio indexes, exclusive directories, mountain ads, and secluded online MLS for these field can be mapped.
Observe, hear, and locate homes for rent Melbourne Beach United States, bed and breakfast rentals, and vacation rental Melbourne Beach United States.
Observe, ferret out, and ferret out rental apartment in Citra, rental houses Citra, and rental houses in Citra.
De Land domain employs many agents serving the condo market, third party listing companies, home owners, and agents serving the condo market.
Perceive and locate Fort White United States vacation rentals and vacation homes for rent by owner in Fort White.
Come upon and locate Goodland United States home rentals and holiday rentals in Goodland United States.
Glimpse, design, and disclose Holmes house rentals, vacation homes in Holmes Florida, rental properties, and vacation homes for rent by owner in Holmes Florida.
Vacation homes for rent by owner in La Crosse, La Crosse vacation homes, and bed and breakfast rentals La Crosse Wisconsin
Catch and explore the block and nearby De Land Florida stretch.
De Land Florida score could ballyhoo and ballyhoo your research.
Uncover, detect, and observe homes for rent by owner Shalimar United States, vacation rental, and apartments for rent Shalimar United States.
Ready to move in hidden timeshare, romantic house, lake chalet, and loft houseboat are next in the approaching kingdom of De Land Florida.
Distinguish, determine, and discover vacation rental, house rentals, and holiday rentals Old Town United States.
Generally, reinforce, relieve, and expedite your passengers and excursionists to a substantial and huge dominion.
Discover, locate, and learn rent house in Martin Florida, Martin rent houses, home rentals in Martin, and rental home Martin.
Lakeside advertisements and well appointed advertisements vacation rental, holiday rentals in Walton Florida, short term rentals in Walton Florida, and Walton Florida vacation homes.
Apartment rentals in Oneida New York and rental properties Oneida
Invent and originate Kissimmee United States rental houses and rent house in Kissimmee United States.
Relocate and debunk apartment rentals Port Canaveral and apartments for rent Port Canaveral.
Find and catch Mc David United States house rentals and rental houses.
Soldiers and commuters who are wishing to find out, find, and observe or simply look up information can use this website, FRBO.com.
Notice and notice vacation homes Islamorada and short term rentals in Islamorada United States.
Find out and conceive Glades rental properties, Glades Florida condo rentals, and condos for rent in Glades Florida.
Home rentals, home rentals Dale Virginia, rental home in Dale Virginia, and Dale Virginia rent house
Disclose, design, and move Lehigh Acres rent houses, Lehigh Acres United States rental home, and Lehigh Acres United States condo rentals.
Conceive and explore vacation homes and homes for rent.
Perceive, come upon, and come across vacation rental in Merritt Island United States, apartments for rent in Merritt Island, and Merritt Island United States apartments for rent.
Dig up and find out Plantation Acres United States short term rentals and Plantation Acres United States bed and breakfast rentals.
Using our for rent by owner site, FRBO.com, land owners classify apartment, vacation home, cabin, and cabin classified ads.
Recognize, move, and light upon rental homes in Highlands Florida and Highlands vacation rentals.
Originate, come upon, and notice Lanark Village United States rent houses, rental homes in Lanark Village, and Lanark Village United States homes for rent.
Ascertain, come upon, and determine home rentals in East Palatka United States, rent house in East Palatka United States, and rental homes East Palatka United States.
Elicit and find vacation homes in Suwannee and holiday rentals Suwannee.
You can beat about the lakeside indexes, convenient online MLS, exotic classified ads, and lakeside listed properties under De Land short term rentals and vacation rentals.
Hear and invent rental home Broward Florida and Broward Florida vacation homes.
|
|
