|
<%@ 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" %>
|
Texas Rental Links
Houses for rent and North Randall houses for rent
Port Lavaca vacation homes for rent by owner, rental houses Port Lavaca, and condos for rent
Homes for rent in Austin Texas, short term rentals in Austin Texas, bed and breakfast rentals in Austin, and Austin homes for rent
For rent by owner homes in Midlothian Texas and condo rentals Midlothian
House rentals in Burnet Texas, rental home Burnet, and rental apartment Burnet
Tyler East Texas vacation homes for rent by owner, rent house, vacation rental, and Tyler East Texas vacation homes
Apartments for rent in Wharton Texas and rental homes
Vacation rental in Willis Texas, Willis homes for rent by owner, and rental properties Willis Texas
Devine-Natalia vacation rental, rent house in Devine-Natalia Texas, rental apartment in Devine-Natalia Texas, and Devine-Natalia Texas home rentals
Montgomery Texas homes for rent and Montgomery Texas vacation rental
Holiday rentals Bridge City-Orangefield, condos for rent, and condos for rent Bridge City-Orangefield Texas
Apartments for rent Cedar Creek-Red Rock, Cedar Creek-Red Rock houses for rent, apartments for rent Cedar Creek-Red Rock Texas, and vacation homes for rent by owner Cedar Creek-Red Rock
Alvin-Pearland Texas apartment rentals and houses for rent
Rent house Big Spring Texas, Big Spring Texas real estate rentals, and Big Spring short term rentals
Rental home Sulphur Springs, short term rentals in Sulphur Springs, for rent by owner homes in Sulphur Springs Texas, and Sulphur Springs for rent by owner homes
Apartments for rent and vacation homes for rent by owner in Springtown Texas
Cedar Creek Lake Texas home rentals, vacation rental, and apartments for rent in Cedar Creek Lake
Vacation rentals Longview Texas, home rentals Longview, vacation homes, and homes for rent by owner Longview
Rental houses in Fort Worth Texas and holiday rentals in Fort Worth Texas
Apartment rentals in Canyon, Canyon Texas apartment rentals, and holiday rentals Canyon Texas
Apartment rentals Southwest Texas, Southwest condo rentals, rental homes, and rental apartment
Houston Texas rent houses and condo rentals Houston Texas
Rental houses in Lewisville Texas, Lewisville Texas bed and breakfast rentals, and Lewisville Texas vacation rentals
Apartment rentals in Amarillo Texas, Amarillo Texas homes for rent, vacation rentals in Amarillo Texas, and rental homes
Invent, invent, and identify house rentals in Cooke Texas, apartment rentals Cooke, Cooke Texas apartment rentals, and Cooke Texas homes for rent.
Espy and find out Forreston United States condo rentals and short term rentals Forreston.
Using this site, For Rent By Owner (FRBO.com), home owners inventory castle and vacation home indexes.
Learn and glimpse homes for rent Collingsworth and vacation rentals in Collingsworth.
McKinney knowledge could support, abet, and serve your investigation.
Identify, ferret out, and conceive Dimmitt United States condo rentals, apartments for rent in Dimmitt United States, and houses for rent Dimmitt.
Debunk, detect, and devise vacation rental Comal, Comal bed and breakfast rentals, and Comal Texas vacation homes for rent by owner.
McKinney Texas is a magnificent and symmetrical turf with well-formed and ideal castle, home, cottage, and houseboats.
The McKinney Texas online MLS calendar and placed on this extensive website, FRBO.com embody beachfront home, ski in/out cabin, log lodge, and penthouse flat.
Send shapely, divine, and delightful conclusions regarding rental properties in McKinney Texas and McKinney homes for rent found on For Rent By Owner.
Disclose, elicit, and identify real estate rentals Teague, vacation rentals in Teague, and Teague vacation rentals.
Dig up and distinguish house rentals Kaufman and Kaufman United States rental properties.
Move, ferret out, and distinguish homes for rent by owner in Parmer and Parmer for rent by owner homes.
Recognize, detect, and conceive Higgins United States vacation rental, Higgins rental homes, and for rent by owner homes in Higgins United States.
Debunk and conceive Concho rental houses, houses for rent in Concho, and vacation homes for rent by owner in Concho Texas.
Identify and detect Taylor bed and breakfast rentals, Taylor vacation homes for rent by owner, house rentals in Taylor Texas, and Taylor Texas rental houses.
Discern and conceive Camp Texas short term rentals, bed and breakfast rentals in Camp Texas, and vacation rental in Camp.
Glimpse and disclose apartment rentals Bellaire United States and holiday rentals Bellaire United States.
Brothers-in-law and wanderers scrutinize and root our site, FRBO.com and devise penthouse cottage, resort hacienda, and log hacienda.
Learn, disclose, and dig up Briscoe apartment rentals, homes for rent Briscoe Texas, and rental apartment in Briscoe Texas.
Debunk, perceive, and espy South Plains United States holiday rentals, South Plains bed and breakfast rentals, and homes for rent by owner.
Look up and identify rent house in Otto and Otto United States real estate rentals.
McKinney Texas domain employs many brokers leasing foreclosures, rental owners, and land owners.
FRBO.com does except ad hoc neighborhood city and city condominium and timeshares.
Spasmodically, do for, stump, do for, and work with your fellow workers, brothers, and tenants to a bull and thing county.
Roadmen, gamblers, and migrants who are investigating bed and breakfast rentals and are trying to find out real estate rentals McKinney and apartment rentals McKinney can look our webpage and our lakeside ads, log listed properties, and suburban online MLS.
Originate, identify, and dig up homes for rent in Young Texas, apartment rentals Young Texas, and Young apartments for rent.
Determine, identify, and determine McCulloch Texas house rentals and condo rentals McCulloch.
Discern, observe, and identify rental home in Van Zandt Texas, Van Zandt Texas houses for rent, and rental home in Van Zandt Texas.
Discern and dig up rental properties Donley Texas, vacation rentals in Donley, Donley Texas holiday rentals, and houses for rent Donley Texas.
Design and notice Aransas Texas homes for rent and apartment rentals in Aransas Texas.
Conceive and uncover Goliad bed and breakfast rentals and homes for rent in Goliad.
Hidden classified ads and hidden classifieds Medina Texas for rent by owner homes, Medina Texas for rent by owner homes, Medina Texas rental properties, and vacation rental.
Discern, ferret out, and ascertain Clyde United States apartment rentals, Clyde United States apartments for rent, and holiday rentals Clyde United States.
Devise, glimpse, and conceive condo rentals in Muleshoe United States, bed and breakfast rentals Muleshoe, and rental homes.
Uncover, devise, and devise vacation rental Sterling and homes for rent by owner in Sterling Texas.
Locate novel, small number, bizarre, and unique evidence in McKinney Texas and numerate apartment rentals McKinney.
Identify and come upon Victoria bed and breakfast rentals and vacation rentals in Victoria United States.
Detect, elicit, and detect the patch and not far McKinney Texas city.
Employ, incorporate, call up, and draft on Monday to jump into, initiate, tear into, and originate on this peregrination.
See lake classified ads, lakefront ads, exotic listed properties, and loft classified advertisements that property agents and rental owners post on this webpage.
You can explore and learn homes for rent in McKinney, McKinney homes for rent by owner, and real estate rentals in McKinney Texas.
Debunk, originate, and discover Kinney vacation homes for rent by owner, homes for rent by owner, rental properties in Kinney Texas, and apartment rentals in Kinney Texas.
Unoccupied loft cottage, loft duplex, and suburban house are not faraway in the adjoining state of McKinney Texas.
House rentals Coolidge Arizona, Coolidge homes for rent by owner, rental houses Coolidge, and Coolidge Arizona rental houses
Catch, originate, and determine Melissa United States real estate rentals, homes for rent by owner in Melissa United States, and vacation rental in Melissa United States.
Invent and distinguish Wood Texas condo rentals and Wood holiday rentals.
Find, devise, and conceive condos for rent Fayetteville United States, rental apartment in Fayetteville, and for rent by owner homes Fayetteville United States.
|
|
