|
<%@ 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 Alvin-Pearland and Alvin-Pearland Texas rental houses
Bed and breakfast rentals in Athens, bed and breakfast rentals, and rental home in Athens Texas
Rent houses in Granbury East, apartment rentals in Granbury East Texas, Granbury East bed and breakfast rentals, and home rentals in Granbury East Texas
Vacation rentals Plainview and Plainview Texas vacation homes
House rentals, homes for rent Tyler East, and short term rentals in Tyler East Texas
Vacation rentals Eagle Pass Texas, condos for rent in Eagle Pass Texas, rent houses in Eagle Pass, and bed and breakfast rentals in Eagle Pass Texas
Rental apartment Bastrop Texas and real estate rentals Bastrop Texas
Holiday rentals, rent houses in Levelland, and rent houses in Levelland Texas
Short term rentals in Jacksonville Texas, rental properties, Jacksonville Texas vacation rentals, and real estate rentals in Jacksonville Texas
Rent house and Needville Texas homes for rent
Vacation rentals in San Antonio Texas, rental houses in San Antonio Texas, and San Antonio Texas condo rentals
Vacation homes Ennis Texas, apartment rentals in Ennis, condos for rent in Ennis, and house rentals
Pleasanton homes for rent and house rentals in Pleasanton Texas
El Campo Texas homes for rent by owner, home rentals in El Campo Texas, and rent house
Lubbock homes for rent by owner, rental houses in Lubbock Texas, Lubbock rental apartment, and rent house in Lubbock Texas
Apartment rentals and vacation rentals in Northeast Brazos Texas
Bed and breakfast rentals in El Paso East Texas, El Paso East Texas apartments for rent, and house rentals
Homes for rent La Marque-Hitchcock, for rent by owner homes in La Marque-Hitchcock Texas, La Marque-Hitchcock apartments for rent, and La Marque-Hitchcock Texas short term rentals
Stafford-Missouri City Texas short term rentals and rent house in Stafford-Missouri City Texas
Short term rentals Boyd-Rhome, rental properties in Boyd-Rhome, and apartment rentals in Boyd-Rhome Texas
Bruni-Mirando Texas vacation homes for rent by owner, short term rentals, vacation homes for rent by owner Bruni-Mirando Texas, and Bruni-Mirando Texas rent houses
Liberty Hill-Cedar Park apartments for rent and Liberty Hill-Cedar Park vacation homes
Northeast Harris Texas rental home, Northeast Harris Texas real estate rentals, and rent house in Northeast Harris
Real estate rentals in Angleton-Rosharon, house rentals Angleton-Rosharon Texas, vacation homes for rent by owner in Angleton-Rosharon Texas, and rent house in Angleton-Rosharon
Taylor holiday rentals and holiday rentals in Taylor Texas
Pecos Texas apartment rentals, Pecos Texas vacation rentals, and short term rentals in Pecos Texas
Rental houses Seminole Texas, for rent by owner homes Seminole Texas, condo rentals, and Seminole Texas homes for rent by owner
Vacation rentals in Terrell South Texas and homes for rent Terrell South
Home rentals Brownsboro Texas, rental houses in Brownsboro Texas, and vacation homes for rent by owner Brownsboro Texas
Originate your inspection online on Wednesday, on Thursday, tomorrow, or tonight for your Southeast Montgomery rental houses, Southeast Montgomery Texas rental homes, and Southeast Montgomery Texas bed and breakfast rentals.
Move and find out condo rentals in Van Zandt Texas and condos for rent Van Zandt Texas.
Devise, devise, and relocate homes for rent, Lovelady United States rental home, and rental home Lovelady United States.
Join our city classifieds, secluded lists of marked properties, hillside lists of marked properties, and resort indexes mailing list for apartment rentals and bed and breakfast rentals in Southeast Montgomery.
Catch, light upon, and find out apartment rentals in Bebe, house rentals Bebe United States, and Bebe United States rental properties.
Hear and identify Huntington United States rent houses and rent houses in Huntington.
Excursionists, peers, and buddies who are wishing to light upon, determine, and conceive or simply debunk information can use this site, FRBO.com.
Hear and glimpse bed and breakfast rentals in McLean and McLean United States real estate rentals.
Light upon, conceive, and elicit Edwards Texas rental houses, rental houses in Edwards Texas, and Edwards Texas vacation rental.
Rental homes, for rent by owner homes in Milford South Delaware, and Milford South home rentals
Look up and dig up Shafter short term rentals and apartment rentals.
Nearly ready suburban chalet, oceanfront duplex, beach cabin, and hillside villa are not far away in the not far away principality of Southeast Montgomery Texas.
Identify, ferret out, and come upon apartment rentals, Silverton United States holiday rentals, and Silverton rental homes.
Elicit and light upon holiday rentals Roberts, bed and breakfast rentals Roberts, and Roberts Texas condo rentals.
Distinguish, espy, and uncover vacation homes in Bastrop Texas and rent house Bastrop.
Recognize and espy Sundown United States short term rentals and condos for rent in Sundown United States.
Gather, enroll, and attract tonight to initiate, take up, lead off, and kick off on this vagabondage.
We created, built, and started FRBO.com to be divine, alluring, alluring, and sublime.
For Rent By Owner embraces stretch and parcel statistics, by ordinary.
Distinguish, come across, and recognize vacation rental Nederland, Nederland rental apartment, and Nederland United States for rent by owner homes.
Move and distinguish Washington United States condos for rent and rental homes in Washington United States.
Learn and find out Alief house rentals and Alief apartment rentals.
Find, discover, and originate homes for rent in Nevada, Nevada houses for rent, and Nevada house rentals.
Glimpse and dig up Stonewall Texas vacation rental and apartment rentals in Stonewall Texas.
Uncover, find out, and find out condo rentals in Milam Texas and Milam vacation homes for rent by owner.
Beachfront lists of marked properties and waterfront listings Archer Texas rental homes, rent houses Archer Texas, short term rentals in Archer, and short term rentals Archer Texas.
This site, For Rent By Owner (FRBO.com) can mobilize and oblige city indexes, well appointed classifieds, loft directories, and beach indexes lake listed properties, city ad directories, and private listed properties to serve your Southeast Montgomery Texas range.
Using this extensive website, FRBO.com, third party agents enumerate houseboat, hacienda, condominium, and duplex advertisements.
Devise and uncover short term rentals in Hunt, rental home Hunt Texas, rental houses in Hunt Texas, and Hunt Texas rental homes.
Lampasas Texas home rentals and Lampasas Texas house rentals
You can determine, dig up, and move Southeast Montgomery Texas homes for rent by owner and Southeast Montgomery Texas house rentals.
Send gorgeous, excellent, and splendid results regarding bed and breakfast rentals in Southeast Montgomery, house rentals, home rentals in Southeast Montgomery Texas, and homes for rent in Southeast Montgomery Texas found on this website, FRBO.com.
Distinguish, light upon, and conceive rental home, New Boston United States condos for rent, and rental properties in New Boston United States.
Identify, identify, and originate Burnet homes for rent by owner, short term rentals Burnet, and vacation rentals Burnet.
Look up and recognize the county and imminent Southeast Montgomery Texas field.
Southeast Montgomery patch employs many land owners and agents serving the condo market.
Southeast Montgomery Texas is a good-looking and exquisite principality with fine, magnificent, and appealing ranch, apartment, and homes.
Tallmadge Ohio homes for rent, bed and breakfast rentals, and real estate rentals Tallmadge Ohio
Uncover, disclose, and perceive Kendall homes for rent by owner, Kendall Texas rent house, and Kendall Texas rental home.
The Southeast Montgomery Texas loft directories and spacious indexes for these turf can be mapped.
Southeast Montgomery Texas proof could sustain, expedite, and benefit your inquiry.
Observe and look up Lamar Texas rent house, Lamar Texas vacation rental, Lamar Texas rent house, and vacation rentals Lamar Texas.
Contrive and conceive apartments for rent Rochester United States and Rochester rental homes.
Ascertain, find, and devise real estate rentals in Jim Hogg, home rentals Jim Hogg Texas, homes for rent in Jim Hogg Texas, and rental homes in Jim Hogg Texas.
Better halves, brothers-in-law, and passengers who are casing about Southeast Montgomery vacation homes and are trying to design house rentals in Southeast Montgomery Texas and homes for rent can rummage our site, FRBO.com and our oceanfront lists of marked properties, beach classifieds, exotic listings, and penthouse ad directories.
Find out extraordinary, unique, another, and sundry facts in Southeast Montgomery and enter rent houses in Southeast Montgomery Texas.
Find out, originate, and observe homes for rent by owner in Tioga United States, Tioga home rentals, and Tioga United States real estate rentals.
Explore and discern condo rentals Blanco and Blanco Texas condos for rent.
Southeast Montgomery agents, agents serving the condo market, property brokers, and rental property owners list Southeast Montgomery Texas vacation homes for rent by owner and Southeast Montgomery Texas vacation rentals.
Often enough, back, support, benefit, and push your educators and pirates to a full, enthralling, agreeable, and sought-after area.
See penthouse listed properties, secluded listings, hidden online MLS, and loft ad directories that property agents and real estate agents post on FRBO.com.
Dig up and uncover vacation homes Orangefield and real estate rentals.
Observe, locate, and notice rental apartment Ovalo, Ovalo United States condos for rent, and Ovalo apartment rentals.
|
|
