Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T18:05:33.110' ,`MLSNumber` = '24754054' ,`ListAgentFullName` = 'David Rainey' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '33.735272' ,`Longitude` = '-82.731722' ,`PhotoCount` = '46' ,`PostalCode` = '30673' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grove' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Street' ,`City` = 'Washington' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grove Street Cottage circa 1900, This Delightful Cottage is set to CHARM the lovers of Older Homes! Featuring Gorgeous Heart of Pine wood floors, Tall Ceilings, Mantled Fireplaces, original six-panel wooden doors, Moldings throughout that include Ceiling & Picture rail as well as wide baseboards that help frame the loveliness of each room! Living/Family Room featuring angled fireplace, large front windows allowing plenty of natural light, and Beautiful stairway with Pine Newel Post! The Kitchen, Charming & Cozy has Fireplace with exposed natural brick and painted mantle, and a neat custom-made wooden island. The Primary Bedroom is also spacious it has two large windows and corner fireplace simply adding to its Warmth & Charm. Grove Street Cottage has undergone many nice updates. This lovely little gem is perfectly located for a Easy and leisurely walk to town square, restaurants, library and shopping. Come and Enjoy Life in a Small Town!!!' ,`Acres` = '0.23' ,`Area` = '81' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '6' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GROVE ST PB9-307GMD164' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Historic Washington' ,`TaxAmount` = '1256' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1900' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213642' WHERE `Matrix_Unique_ID` = '209015984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:04:36.400' ,`MLSNumber` = '29559052' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Xue Yang' ,`SellingOfficeName` = 'Forever Realty' ,`Latitude` = '29.570846' ,`Longitude` = '-95.738670' ,`PhotoCount` = '8' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '634557.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Colonel Fields' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston V, Elevation B) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Game Room, 4 bedrooms, and 3 bathrooms upstairs. Covered patio and 2 car attached garage. Spanning nearly 600 acres of beautiful homes, lush landscaping, trails, and exciting amenities, Veranda embodies the legacy of historic Richmond with all the comforts of a luxurious master-planned community. Minutes to the newly expanded I-69 and the Grand Parkway, you are near exceptional shopping, dining and recreation. Stop by the Westin Homes model home today to find out more about Veranda!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8154' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213642' WHERE `Matrix_Unique_ID` = '209353251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T18:15:31.663' ,`MLSNumber` = '66809959' ,`ListAgentFullName` = 'Mark Bonning' ,`ListOfficeName` = 'Bonning Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214262' ,`Longitude` = '-95.796477' ,`PhotoCount` = '50' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Hempstead' ,`StreetNumber` = '34410' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'River Park Ranch is a premiere 1000-acreage custom home equestrian community, that boasts an 18-acre private fishing lake, waterfront park, walking trails, riding easements, and best of all, no mud taxes! This beautiful custom home sits on 9.79 picturesque acres. This home has 4 bedrooms and 3 and a half baths, a study, and a formal dining room with an adjoining wine bar. There are 2 bedrooms, a bathroom, a large Game room with vaulted ceilings, and a separate library. This large Island kitchen with stainless appliances, a breakfast bar, and brick paver floors, opens to the family and breakfast room. The oversized 3-car garage has a full garage apartment with a kitchenette above. There is a fabulous 6 Stall Horse barn, with 2 offices/feed/tack and hay storage and a rear-covered equipment area. Fenced and cross-fenced pastures with loafing sheds. A large metal building is ideal for storing an RV, Boat, or tractor. There is also a covered gazebo close to the fishing pond.' ,`Acres` = '9.792' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'A0260 HILLHOUSE WM, TRACT 2-A (00), 15-C (01), ACRES 9.792' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Wooded' ,`LotSize` = '426540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'River Park Ranch' ,`TaxAmount` = '12800' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213643' WHERE `Matrix_Unique_ID` = '212683721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:11:33.737' ,`MLSNumber` = '79258857' ,`ListAgentFullName` = 'Jessica Salinas' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806959' ,`Longitude` = '-95.136827' ,`PhotoCount` = '23' ,`PostalCode` = '77049' ,`RoomCount` = '5' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Rancho Grande' ,`StreetNumber` = '1659' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this 4 bedroom, 2 bath, 2 car garage in the lovely community of Rancho Verde. One story, high ceilings, split floor plan, open concept, popular highly desired floor plan Great curb appeal, with lush landscaping, widened driveway with insert lights, storage shed, no back neighbors. SOLAR PANELS, for a low electricity bill. Great community, with a club house and large pool. Minutes away from schools, Beltway 8, I-10, and 6-10. Great home, in a convenient location, near all the shopping amenities. Call for your private showing today.' ,`Acres` = '0.1188' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 RANCHO VERDE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rancho Verde' ,`TaxAmount` = '5385' ,`TaxRate` = '2.618' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213643' WHERE `Matrix_Unique_ID` = '213317110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:28:33.167' ,`MLSNumber` = '30973245' ,`ListAgentFullName` = 'Carlee Garnett' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.445815' ,`Longitude` = '-95.329131' ,`PhotoCount` = '10' ,`PostalCode` = '77578' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Acres Dr' ,`StreetNumber` = '9415' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is an investment property. This home has 3 bedrooms and sits on a 2 acre property. This is NOT in a flood zone! Great for an investor to fix and flip. Please text agent to show.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'unknown' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'unknown' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675213643' WHERE `Matrix_Unique_ID` = '213346777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:26:16.093' ,`MLSNumber` = '58797684' ,`ListAgentFullName` = 'Shelby Crowe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434056' ,`Longitude` = '-95.440233' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Langley' ,`StreetNumber` = '2315' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home 2315 Langley is just waiting for YOU!!!-This gorgeous 2 story Castlerock home with a large backyard-you can have your own oasis-open floor plan-luxurious master downstairs with large walk in closet, his and her sinks soaking tub with separate shower-spacious living area open to the kitchen-laundry room downstairs-kitchen has an island-upstairs you have 3 bedrooms 2 baths and a game room-open to the down stairs--lots of windows for natural light-high ceilings-conveniently located within walking distance to the playground and doggie park-Master-planned community-easy access to 288-restaurants-drug stores-within 3 miles of the new Manvel town center with the new H E B under construction-new family pool under construction opening spring 2023-this one won\'t last long -Call today for your personal tour' ,`Acres` = '0.1377' ,`Area` = '5' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 4 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista Sec 2' ,`TaxAmount` = '10616' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213643' WHERE `Matrix_Unique_ID` = '213352413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:21:43.273' ,`MLSNumber` = '48935700' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599877' ,`Longitude` = '-95.226451' ,`PhotoCount` = '21' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkwell' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a GREAT HOME with updated features! SPACIOUS bedrooms…Freshly painted in and out...NEW PLUSH Carpet... NEW Stainless-steel appliances…NEW flooring…NEW Ceiling fans…NEW hardware throughout the house…Too many updates!! you must see it for yourself…Your search is over! DON\'T MISS OUT!!' ,`Acres` = '0.1286' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 & TR 23B KIRKWOOD SOUTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood South Sec 06' ,`TaxAmount` = '4563' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213644' WHERE `Matrix_Unique_ID` = '213553599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T18:44:12.890' ,`MLSNumber` = '37758199' ,`ListAgentFullName` = 'Roxanna Saldana' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589316' ,`Longitude` = '-96.332474' ,`PhotoCount` = '25' ,`PostalCode` = '77434' ,`RoomCount` = '5' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Street' ,`City` = 'Eagle Lake' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great property as a starter home, investment or looking to downsize. Great location in Eagle lake close to downtown and no neighbors to left of property. This 2 bedroom 1 bath home is ready for their new owners to make it their own. The home has an additional room that can be used as an office/play room or what fits your needs. A cute shed in the back yard ready to convert into your own little spot or for additional storage. The last pictures show the home virtually staged so that you can imagine the endless possibilities. Come take a look!' ,`Acres` = '0.12' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 37 LT 11 EAGLE LAKE HOUSE & BLDG' ,`LotDesciption` = 'Other' ,`LotSize` = '5227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'EAGLE LAKE INTERMEDIATE SCHOOL' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Eagle Lake' ,`TaxAmount` = '1446' ,`TaxRate` = '2.5343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213644' WHERE `Matrix_Unique_ID` = '213604752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T18:17:59.283' ,`MLSNumber` = '74088787' ,`ListAgentFullName` = 'Enrique Martinez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884221' ,`Longitude` = '-95.477684' ,`PhotoCount` = '28' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Lawn' ,`StreetNumber` = '8018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS WILL BE YOUR FUTURE HOME.!Don\'t miss this one Won\'t las too long .! AC System was installed brand new in 2021.\r\nThis House has a beautiful Crystal clear water Pool Which has a very nice view from Master Bedroom with sliding doors. You,Your family and Friends will enjoy Your pool parties.Very close to main Freeways,Schools and all kind of stores.' ,`Acres` = '0.2089' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 12 INWOOD FOREST SEC 12' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Inwood Forest Sec 12' ,`TaxAmount` = '6374' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213644' WHERE `Matrix_Unique_ID` = '213623379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:43:40.750' ,`MLSNumber` = '30595808' ,`ListAgentFullName` = 'Maihuong Nguyen' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758951' ,`Longitude` = '-95.869824' ,`PhotoCount` = '42' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Parker Ridge' ,`StreetNumber` = '28943' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, beautiful 2 story home w 4 beds, 3 full baths & a half bath, study room, 2 car tandem garage. Beautiful elevation w stucco, 4 sided brick at corner lot. Wood floor throughout except for carpet in master bedroom on first level. Beautiful kitchen features gray cabinetry w plenty of cabinets, quartz countertop, stainless steel appliances: vent hood, gas cooktop, built in oven and microwave, dishwasher, fridge. Spacious family room with high ceiling, large windows with natural light. House comes with over $5k roll up curtains. Family room opens to breakfast area and kitchen. The master ensuite features a spacious living space, separate garden tub and shower, walk in closet, double vanities. Big game room and other 3 bedrooms on second level. Fridge, washer, dryer stay. Community amenities offer pool, tennis courts, lakes and trails, fitness center, clubhouse and more. Lamar Consolidated ISD. Never flooded. Close to I-10 and 99. Lot of shopping nearby. Low tax rate. Ready to move in.' ,`Acres` = '0.2157' ,`Area` = '30' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 19, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne West Sec 19' ,`TaxAmount` = '1406' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213644' WHERE `Matrix_Unique_ID` = '213818584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T18:20:06.997' ,`MLSNumber` = '64918667' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565857' ,`Longitude` = '-95.019160' ,`PhotoCount` = '32' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Cedarbrook' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is situated on a quiet, cul-de-sac street, with access to great restaurants, shopping & more! A leaded glass door will invite you in. Once inside, notice the updated tile flooring in Entry, which transitions to laminate flooring throughout the home. Stacked Formals are perfect for entertaining family & friends. The Family Room is the heart of the home! It features a gorgeous, corner fireplace accented with brick. Boasting a 5 burner gas range, built in oven & microwave, updated cabinetry & trendy subway tile backsplash, this Kitchen is sure to please the chef in the home! The Primary Bedrooms has an ensuite with updated cabinetry & tiled tub/shower. All bedrooms boast a walk-in closet, so there is plenty of room to store your belongings! The secondary bathroom is spacious and has updated, tiled tub/shower. The Game Room is a great place for Friday fun night, or it could be used as a workout area. Spacious backyard is complete with canopy and covered patio!' ,`Acres` = '0.2066' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 2 BAYBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Baybrook' ,`TaxAmount` = '4363' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213645' WHERE `Matrix_Unique_ID` = '214217835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:00:53.750' ,`MLSNumber` = '7560149' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Nikki Thibeaux' ,`SellingOfficeName` = 'RE/MAX Pearland' ,`Latitude` = '29.807387' ,`Longitude` = '-95.836024' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '15' ,`ListPrice` = '639983.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Poplar Meadow' ,`StreetNumber` = '6523' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Rowan XL, Elevation AP) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large walk-in closet and secondary bedroom on first floor. Two additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Located in the heart of Katy and minutes from the Grand Parkway and I-10, the Falls at Green Meadows is Katy’s premiere Community! Residents of the Falls at Green Meadows can enjoy the Community Recreation Center that features a crystal-blue pool and outdoor patio area. Other amenities include sparkling lakes, meandering walking trails, and a playground. Stop by the Westin Homes model home today to find out more about the Falls at Green Meadows!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 42 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9096' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Green Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213645' WHERE `Matrix_Unique_ID` = '214249223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T17:35:13.297' ,`MLSNumber` = '8687502' ,`ListAgentFullName` = 'Susan Boss' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780007' ,`Longitude` = '-95.506208' ,`PhotoCount` = '49' ,`PostalCode` = '77024' ,`RoomCount` = '15' ,`ListPrice` = '2100000.00' ,`Status` = 'Active' ,`StreetName` = 'Brogden' ,`StreetNumber` = '805' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '6397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom home built for Engineer and Designer in 2000. Kitchen open to living and breakfast rooms with view of pool. 5th bedroom attached to guest suite with return stairs and separate entrance. Game room, formal living, study with vaulted ceiling, craft room, catering area in laundry room, pool, grassy play area, oversized 3 car garage, circular drive, and extra parking.' ,`Acres` = '0.5457' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30A HEDWIG CIRCLE R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '23772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hedwig Village' ,`TaxAmount` = '36103' ,`TaxRate` = '2.2564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213645' WHERE `Matrix_Unique_ID` = '214287068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T18:55:34.100' ,`MLSNumber` = '95492943' ,`ListAgentFullName` = 'Marissa Garlington' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.964237' ,`Longitude` = '-94.973319' ,`PhotoCount` = '32' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 48820' ,`StreetNumber` = '311' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the country! This 3 bedroom almost 1 acre home is everything your looking for, can be your homestead property or your getaway property on the weekend. Home has gorgeous landscaping, owner put lots of pride into her garden. Home also comes with shed and a little house on the side for your work out equipment or whatever you would like to use it for. Please come view this little \"gem\" of a home. You truly won\'t be disappointed!!!' ,`Acres` = '0.88' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR CREEK, SEC 3, BLOCK 10, LOT 4, ACRES .88' ,`LotDesciption` = 'Cleared' ,`LotSize` = '38333' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Creek, Sec 3' ,`TaxAmount` = '1281' ,`TaxRate` = '1.9062' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213645' WHERE `Matrix_Unique_ID` = '214836593' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215044427','1675213646','215044427','2023-01-17T17:27:05.950','34454809','Steve Soyebo','SpectrumSource Realty','','','29.982433','-95.676208','32','77429','6','269900.00','Active','Golden Cypress','14319','Lane','Cypress','2','0','3','1674','Single-Family','Newly renovated & upgraded 3 Bedroom, 2 full baths home ideally situated minutes from the Hwy-290 commercial hub. Home upgraded with Granite countertops in Kitchen & bathrooms, Tile & Laminate wood flooring throughout the home, fresh paint, Crown Molding, French doors. Bathrooms updated with beautiful wall tiles & accents. Spacious Kitchen features a Range stove & ample cabinet space. Exterior features a large 28x10 covered patio & fenced backyard ideal for gatherings & relaxation.\r\n***SCHEDULE A SHOWING FOR YOURSELF TODAY**','','35','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 5 BLK 1 CYPRESS POINT SEC 1','Subdivision Lot','6600','Appraisal District','','575','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','FARNEY ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','GOODSON MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Cypress Point 1','','','Public Sewer,Water District','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215268443','1675213646','215268443','2023-01-17T17:07:05.220','29714373','Ben Caballero','Highland Homes Realty','','','30.403370','-95.511023','11','77318','8','440000.00','Active','Lukewood','143','Circle','Willis','3','0','4','2360','Single-Family','MLS# 29714373 - Built by Highland Homes - Ready Now! ~ Open plan with tall ceilings. Family room opens to island kitchen with two-tone cabinets (white upper and natural lower), white countertops and stainless appliances inclusive of single basin island sink, and walk-in pantry. Wood-look flooring throughout main living areas. All bedrooms have walk-in closets. Pimary Bed has bay window sitting area. Primary bath with free standing tub and separate shower. Extended Covered Patio. Tankless water heater and Smart Home Technology also included as well as full sod yard and sprinkler system. Easy Access to schools, shopping, dining and medical facilities','','39','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','0','Lake Conroe Area','Central Gas','1','Lot 16 Block 2','Subdivision Lot','5845','Survey','','995','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Leave Business Card,No Appointment Required','Builder','2','Traditional','The Woodlands Hills','','3.2','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215291110','1675213646','215291110','2023-01-17T17:28:20.657','44973435','Leslie Castilleja','Sierra Vista Realty LLC','','','29.501367','-95.443635','17','77583','6','310000.00','Active','Stone Bluff','14215','Lane','Rosharon','2','0','3','1910','Single-Family','Welcome to Lakes of Savannah in Rosharon! This stunning home features a spacious open floor plan and offers lots of space for growing families. Upgrades included: NEW carpet, window screens and microwave. Roof was replaced in 2022. It is located in Alvin ISD with remote access to 288, Beltway 8 and the Medical Center. Minutes away from lots of dining, retail and entertainment at Pearland Town Center. This Mastered Plan Community has unbeatable amenities such as pools, club houses, parks and splash pads.','0.1556','5','Lennar','','Washer Connections','','Exclusions,Mud,Sellers Disclosure','','','1','Alvin North','Central Gas','1','SAVANNAH RIDGE SEC 2 (A0403 ACH&B) BLK 1 LOT 3','Subdivision Lot','6778','Appraisal District','','670','0','','2','','0','','','Gas Range','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Savannah Ridge Sec 1-2-3','7029','3.1908','Public Sewer,Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215316211','1675213646','215316211','2023-01-17T18:49:48.503','64517994','Lacy DeSouza','Coldwell Banker Realty','','','30.072561','-94.762622','17','77575','6','218000.00','Active','Mimosa','113','Lane','Liberty','2','0','3','1659','Single-Family','COUNTRY LIVING CLOSE TO TOWN. This charming three (possibly four) bedroom, two bathroom home is situated on picturesque half acre lot on a quiet dead end street with NO BACK NEIGHBORS. This home is MOVE IN READY and checks all the boxes. Upon entry you you are greeted by a fresh and inviting living room with luxury vinyl plank flooring that flows throughout the home and new paint. A spacious sun-filled eat in kitchen is sure to please with its gas range, granite countertops, ample white cabinetry, and space to comfortably fit a six person table. Primary bedroom is a sanctuary with brand new carpet and ensuite bathroom. Family room has a closet and could work as a fourth bedroom. Secondary bedrooms are generously sized with a bathroom conveniently located between them. Other features include energy efficient windows, Roof 2020, HVAC<5yr, beams and joists treated and subfloor on original pier and beam replaced. City sewer and water, but you can choose your electric provider. NO FLOODING.','0.5','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Liberty','Central Gas','0','000073 JAMES MARTIN, TRACT 145, ACRES .5','Cleared','21780','Appraisal District','','','0','','1','Freestanding Oven','0','','','Freestanding Range,Gas Range','','Composition','73 - Liberty','LIBERTY ELEMENTARY SCHOOL (LIBERTY)','LIBERTY HIGH SCHOOL (LIBERTY)','LIBERTY MIDDLE SCHOOL (LIBERTY)','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','James Martin','3891','2.5275','Public Sewer,Public Water','1956','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215392312','1675213646','215392312','2023-01-17T17:36:40.373','4200315','Rhonda Washington','Coldwell Banker Realty','','','29.549065','-95.491696','16','77545','11','314900.00','Active','Cottage Step','2618','Trail','Fresno','2','1','4','2462','Single-Family','Nestled in the highly sought-after neighborhood of Winfield Lakes North Sec 1 subdivision, this lovely 4-bedroom, 2.5-bathroom home with a two-car garage is a perfect place to call home. Enjoy your granite kitchen countertops as you entertain friends and family while looking out into your large family room. You will have plenty of kitchen storage with your 42” Maple Upper Kitchen cabinets which have a rich walnut color. This home boasts a large upstairs game room for hours of fun and entertainment. Recharge from a hard day’s work as you relax in your huge garden tub located in your master suite. Enjoy your huge backyard with ample space for plenty of family cookouts or summer gatherings. This home is in excellent condition but needs a little TLC. Seller is motivated! Don’t miss out on this opportunity!','0.1276','38','Lake Ridge Builders','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Missouri City Area','Central Gas','1','WINFIELD LAKES NORTH SEC 1, BLOCK 2, LOT 5','Subdivision Lot','5557','Appraisal District','','550','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','PARKS ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Winfield Lakes North','7459','3.0229','Water District','2016','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216013851','1675213646','216013851','2023-01-17T18:39:49.193','52683350','Valerie Shumate','Southern Star Realty','','','30.433015','-95.485487','26','77378','10','229000.00','Active','Danville','1005','Street','Willis','2','0','3','1552','Single-Family','Excellent little home superbly located in the heart of Willis!! Completely remodeled inside and you will fall in love with all the updates. 3 bedrooms, 2 baths, with the option of a 4th bedroom or game room. Oversized backyard. New tile floors throughout. Kitchen and bathrooms have beautiful granite countertops. Large living room. New stove and oven. Roof was replaced in June 2020 along with new A/C unit, duct work and hot water heater. This home is a must see to appreciate all its beauty.','0.2208','19','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Willis Area','Central Gas','0','NORTHWOOD HEIGHTS, BLOCK 4, LOT 6','Subdivision Lot','9620','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','56 - Willis','C.C. HARDY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Northwood Heights','1837','2.4131','Public Water','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216053976','1675213646','216053976','2023-01-17T17:50:05.293','9983589','Gary Bisha','My Castle Realty','','','29.843598','-95.792686','25','77493','10','365000.00','Active','Sabino Bend','4806','Lane','Katy','2','1','4','2294','Single-Family','You are going to love living here! Meticulously maintained former Lennar model home. 4/2.5/2 plus flex/game room. Great views of the lake are yours to enjoy every day. Upgrades galore: soaring ceilings, stainless steel appliances, granite countertops, water softener, sprinkler system and more. First floor primary bedroom features an ensuite bathroom with a double vanity, oversized shower with a built-in bench, and large walk-in closet. Spacious pool size backyard Located just a block away from Paetow High School (2021 5A-Division I football State Champions), easy access to US-99, I-10, Katy Mils and abundant amenities. Furnishings available separately.','0.1683','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','LT 12 BLK 3 PORTER RANCH SEC 1','Subdivision Lot,Water View','7329','Appraisal District','','700','0','','2','Single Oven','0','','','Gas Range','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Request Online Appointment','Appraisal District','2','Traditional','Porter Ranch','9483','3.2768','Public Sewer,Water District','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216111894','1675213646','216111894','2023-01-17T17:01:02.877','6894302','Christopher Ward','Orchard Brokerage','Alicia Jammer','Compass RE Texas, LLC','29.618114','-95.567945','30','77477','16','599000.00','Pending Continue to Show','Promenade Estates','218','Lane','Stafford','3','1','4','3731','Single-Family','Click the Virtual Tour link to view the 3D walkthrough. Gorgeous brick exterior welcomes you home! This 2 story residence is move-in ready with adequate space to suit everyone’s needs with an ideal floor plan. The kitchen is every chef’s dream with ample counter space, dark cabinetry, stainless steel appliances, kitchen island & complimentary backsplash. Enjoy your meal in either the breakfast area or in the dining room. Hard surfaced floors throughout the main level and second floor. The living room is beaming with natural light and the all white stone fireplace will keep guests warm during the winter months. For extra privacy, the spacious primary bedroom is located on the first floor and boasts double sinks, separate shower, garden tub, and has 2 walk-in closet with built-in shelves. Secondary bedrooms are very spacious & have walk-in-closets Outdoor kitchen & Large screened patio. Also has one of the largest lots in the neighborhood. Your new oasis awaits! New wood flooring (2019)','0.3045','29','','','Washer Connections','','Mud,Sellers Disclosure','1','','1','Stafford Area','Central Gas','1','ESTATES AT PROMENADE SEC 2, BLOCK 2, LOT 25','Subdivision Lot','13263','Appraisal District','','590','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','50 - Stafford','STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)','STAFFORD HIGH SCHOOL','STAFFORD INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Estates At Promenade Sec 2','9412','1.9342','Water District','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216323903','1675213646','216323903','2023-01-17T17:51:54.757','71349627','Jared Turner','LennarVillageBldr-JaredTurner','','','29.835551','-94.990106','6','77521','8','295000.00','Active','Sterling Arbor','9606','Drive','Baytown','2','0','4','1930','Single-Family','BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Homes Wildflower IV Collection in Sterling Point! The Violet, Elevation \"B\" - The kitchen, Great Room and dining room are arranged among a convenient and contemporary open floorplan in this single-level home, offering access to a covered patio for effortless outdoor living and entertaining. The owner’s suite is located at the back of the home, comprised of a restful bedroom, en-suite bathroom and dual walk-in closets. Three more bedrooms are situated down a hallway off the foyer.**Estimated Completion Date, March 2023**','','2','Lennar Homes','','','','Mud,Other Disclosures','','','','Baytown/Harris County','Central Gas','1','SEC 0003 BLK 003 LOT 020','Subdivision Lot','','','','950','1','To Be Built/Under Construction','3','','0','','','','','Composition','23 - Goose Creek Consolidated','PUMPHREY ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Sterling Point','','3.735','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216338603','1675213646','216338603','2023-01-17T17:03:16.830','32983011','Jenny Martinez','Vive Realty LLC','','','30.219789','-95.137403','15','77372','4','239999.00','Active','Westgate','15435','Road','Splendora','1','0','2','990','Single-Family','Back on the MARKET!!!\r\nBeautiful Country living on OVER 1 ACRE of GATED LAND!!\r\nThis gorgeous 2 bedroom home sits on over 1 acre. Gated entryway to property. Recently UPDATED with detailed crown molding in ALL ROOMS. New flooring in the ENTIRE HOME. The KITCHEN has plenty of cabinets and counter space, with new recess lights and new tile. BEDROOMS have new plush carpet and ceiling fans. There is also potential for a POND that sits on the land. This gorgeous home with LAND is perfect to pasture livestock. This home is secluded, cleared, and very maintained with plenty of tree coverage throughout the property. Covered front porch and covered back porch. Storage /Sheds for all your tools, supplies and equipment. Conveniently located just miles off the highway..NO RESTRICTIONS, LOW Montgomery County Taxes, SEPTIC TANK/WELL WATER. The home has NEVER FLOODED.','1.331','40','','','','','Sellers Disclosure','0','','','Cleveland Area','Central Electric','0','S453500 - EASTWOOD 01, RES A-2, ACRES 1.331','Subdivision Lot,Wooded','57978','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Ranch,Traditional','Eastwood 01','2636','2.0783','Septic Tank,Well','2012','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216345660','1675213646','216345660','2023-01-17T18:47:19.223','36163410','Josh Rodriguez','Josh Realty','','','29.855037','-95.607621','32','77041','4','389995.00','Active','Henniker','5743','Drive','Houston','2','1','4','2457','Single-Family','Welcome to 5743 Henniker Drive! Located in great area right off Eldridge Parkway. This home is move in ready! Beautiful ceramic tile, new Calacatta countertops, and LED lighting are just some of the new updates in the home. Home offers a very open layout on the first floor and great sized bedrooms on the second floor. Enjoy the hot Texas summers in your own crystal clear private pool. Long driveway with a detached garage. Stunning brick offers excellent curb appeal- this is the home to host your favorite get togethers! Schedule an appointment today to see this beauty for yourself.','0.1515','8','','','','','Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Eldridge North','Central Gas','1','LT 34 BLK 1 CONCORD BRIDGE SEC 7 R/P','Subdivision Lot','6600','Appraisal District','','475','0','','1','','1','In Ground','','','','Composition','13 - Cypress-Fairbanks','LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Concord Bridge Sec 07 R/P','6943','2.471','Water District','1992','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216385598','1675213646','216385598','2023-01-17T18:31:49.787','8157559','Judy Tully','Vortex Realty','','','29.824191','-95.510417','22','77080','9','400000.00','Active','Knoll','3307','Street','Houston','2','0','3','1667','Single-Family','Come check out this spacious 3/2 private cul-de-sac home! Beautiful hardwoods throughout with tile in kitchen, utility room, den and baths. Mature trees, 0.38 acre lot, cedar deck, large covered cedar patio. Beautiful pool with carved surround stone, perfect for cooling off in the Texas summers. Fans in all rooms. The kitchen boasts granite counters with a peninsula and 5 burner gas stove. Both baths have been updated with tiled walk in showers\r\n207 KW Generac whole house generator. Great starter home or for those looking to downsize.','0.3825','24','','','Washer Connections','','Sellers Disclosure','','','','Spring Branch','Central Electric','0','LT 296 BLK 5 BINGLEWOOD SEC 3','Cul-De-Sac','16660','Appraisal District','','','0','','2','Gas Oven','1','Gunite,In Ground','','','','Composition','49 - Spring Branch','EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','NORTHBROOK MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Binglewood Sec 03','6785','2.4415','Public Sewer,Public Water','1957','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216457609','1675213646','216457609','2023-01-17T17:13:37.783','97938296','Ruby Miranda','Keller Williams Realty - Clear Lake/ NASA','','','29.680183','-95.192073','22','77502','3','225000.00','Active','Mulberry','2121','Lane','Pasadena','1','0','3','1211','Single-Family','Three (3) Bedrooms and 1 full bath home in the heart of Pasadena. Updated Kitchen. CONVERTED GARAGE can be used as a game room or another bedroom. Washer / Dryer connections inside in laundry room. Large yard. Stove included. Ready Schedule your appointment asap. Close to schools, shopping and major highways.','','6','','','','','Sellers Disclosure','','','','Pasadena','Central Gas','0','LT 11 BLK 2 STRAWBERRY HILL SEC 1','Subdivision Lot','6540','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','MAE SMYTHE ELEMENTARY SCHOOL','SAM RAYBURN HIGH SCHOOL','SOUTHMORE INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Strawberry Hill Sec 01','','','Public Sewer,Public Water','1954','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216460116','1675213646','216460116','2023-01-17T18:09:16.447','85832216','Jared Turner','LennarVillageBldr-JaredTurner','','','29.756047','-95.880634','12','77423','7','360000.00','Active','Boxwood','30807','Drive','Fulshear','2','0','3','1792','Single-Family','NEW! Village Builders Bristol Collection \"Beckham\" Plan with Elevation \"D\" in Jordan Ranch! This single-story home has everything you need with three bedrooms in total and an open concept living area. Two bedrooms share a hall bathroom at the front of the home, while down the hall is the family room, kitchen and dining room with access to the back porch. Tucked into the back corner is the owner’s suite, which has a private bathroom and walk-in closet.\r\n****HOME ESTIMATED TO BE COMPLETE, APRIL 2023**','','30','Village Builders','','','','Mud,Other Disclosures','1','','','Katy - Southwest','Central Gas','1','SEC 0034 BLK 001 LOT 042','Subdivision Lot','','','','1050','1','To Be Built/Under Construction','','','0','','','','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Jordan Ranch','','3.19','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216461529','1675213646','216461529','2023-01-17T18:09:49.597','48472565','Jared Turner','LennarVillageBldr-JaredTurner','','','30.164095','-95.190673','8','77357','7','360000.00','Active','Lazzaro Springs','18970','Drive','New Caney','2','1','3','2386','Single-Family','NEW Lennar Homes Fairway Collection, \'\'Cabot\" Plan, Elevation G in Beautiful Tavola - Gorgeous 1 Story home - 3 bedroom, 2.5 bath, 2 car garage, plus Study. Open Island Kitchen w/ 42\'\' Cabinets, Sparkling Countertops, Breakfast/Dining room & Great Appliance Pkg! Generous Open Family room, Master Suite w/ Super Shower & roomy Walk-In Closet. Beautiful Hard Surface Floors in all areas except Bedrooms; Covered Back Patio, Energy Efficient 16 SEER HVAC System','','40','Lennar Homes','','','','Mud','1','','','Porter/New Caney East','Central Gas','1','Tavola 42, BLOCK 5, Lot 6','Subdivision Lot','','','','1125','1','To Be Built/Under Construction','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Tavola','','3.5826','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216464358','1675213646','216464358','2023-01-17T18:10:53.133','80739739','Jared Turner','LennarVillageBldr-JaredTurner','','','30.085514','-95.183295','8','77365','7','350000.00','Active','Warwick River','3525','Trail','Porter','2','0','3','1990','Single-Family','Brand New Lennar Fairway Collection home in Royal Brook at Kingwood! The beautiful 1-story Blackstone E plan by Lennar features an inviting front porch and entry foyer, a dining room, an island kitchen with walk-in pantry and breakfast room that offers access to a relaxing covered rear patio, a generous open family room, and a walk-in utility room. The master bedroom features an en suite master bathroom with dual sinks, stand-up shower, private toilet enclosure, and access to a large master closet.','','32','Lennar','','','','Mud','','','','Kingwood East','Central Gas','1','SEC 0017 BLK 003 LOT 002','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','','','0','','','','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Kingwood Royal Brook','','2.58','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216464859','1675213646','216464859','2023-01-17T18:11:26.610','97161974','Jared Turner','LennarVillageBldr-JaredTurner','','','29.476540','-95.169525','11','77573','7','448990.00','Active','Maplewood','823','Drive','League City','2','1','3','2386','Single-Family','NEW! Lennar Fairway Collection \"Cabot\" Plan with Elevation \"E\" in Westwood! A single-story layout with a large covered patio, this home offers private bedrooms with a shared bathroom near the foyer. Beyond the foyer is a spacious kitchen that overlooks the dining room and family room. Nearby is the owner’s suite which features a large shower with seating and an oversized walk-in closet. *HOME ESTIMATED TO BE COMPLETE, APRIL, 2023*','','33','Lennar Homes','','','','Other Disclosures','','','','League City','Central Gas','1','SEC 0009 BLK 006 LOT 025','Subdivision Lot','','','','540','1','To Be Built/Under Construction','2','','0','','','','','Composition','9 - Clear Creek','CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR SPRINGS HIGH SCHOOL','CREEKSIDE INTERMEDIATE SCHOOL','Appointment Required','Builder','1','Traditional','Westwood','','3.07','Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216469349','1675213646','216469349','2023-01-17T18:39:48.960','79433973','Kaylon Hebert','RE/MAX Signature','','','29.296355','-94.922033','50','77554','7','895000.00','Active','Castaway','1618','Street','Tiki Island','2','0','3','2148','Single-Family','Looking for the perfect island home? Located right off Tiki Lake! From the heated saltwater cocktail pool to the amazing outdoor kitchen and everything in-between, this home will take your breath away. This home is nestled on one of the widest canals on Tiki Island. Inside, you\'ll be greeted by a welcoming open floor plan. High-end Viking fridge & oven are some of the best in the industry! The living area’s many hurricane rated back windows offer tons of natural light and amazing views. The primary retreat is complete with a large spacious walk-in closet, its own wood burning fireplace and attached sunroom/ office space that looks out to beautiful water views! Storm shutters on the front & side of the house, whole home water softener system, mosquito system with demand spraying, surround sound speakers outside, sprinkler system, ADT security system and cameras, Wi-fi thermostat, boat lift, kayak/jet ski lifts, Metal roof, Pecky cypress on exterior ceiling and so much more!','0.135','33','','','','','Exclusions,Other Disclosures,Sellers Disclosure','1','','1','Tiki Island','Central Electric','1','ABST 7 S C BUNDICK SUR LOT 29 TIKI ISLAND SEC 7','Water View,Waterfront','5881','Appraisal District','','100','0','','0','Electric Oven','1','Heated,In Ground,Salt Water','','Electric Cooktop','','Aluminum','26 - Hitchcock','HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL','HITCHCOCK HIGH SCHOOL','CROSBY MIDDLE SCHOOL (HITCHCOCK)','Appointment Required,Supra Keybox','Appraisal District','1.5','Traditional','Tiki Island','12729','2.2119','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216476977','1675213646','216476977','2023-01-17T17:02:32.900','25654522','Cynthia Disney','Results Real Estate','','','29.726834','-94.964118','26','77520','6','154999.00','Active','Briarwood','410','Drive','Baytown','1','0','3','1196','Single-Family','This quaint 3 Bedroom home is nestled in the subdivision of Lawndell, sitting on an oversized corner lot. Unique to the neighborhood, this home has a 620 SQ FT mother in law quarters located in the large fenced in backyard with a full kitchen and bathroom. Kitchen has been upgraded along with tile located throughout all the main living areas. Conveniently located minutes away from the newly build SH 99, 146 and Spur 330. Nearby is Pirates Bay Waterpark, Baytown Airport, AR\'s Entertainment Hub, Restaurants and Entertainment! Schedule your private tour today, this home won\'t last long!','0.2187','2','','','Gas Dryer Connections','','Sellers Disclosure','0','','','Baytown/Harris County','Central Gas','0','LT 6 BLK 13 LAWNDELL SEC 2','Corner,Cul-De-Sac','9527','Appraisal District','','','0','','1','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','ASHBEL SMITH ELEMENTARY SCHOOL','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Other Style','Lawndell Sec 02','2583','2.97','Public Sewer,Public Water','1952','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216478877','1675213646','216478877','2023-01-17T17:43:11.500','15327105','Robert Moore','Perry Homes Realty, LLC','','','30.272160','-95.473020','15','77304','6','425900.00','Active','Sand Branch','636','Drive','Conroe','2','0','3','1910','Single-Family','PERRY HOMES NEW CONSTRUCTION! Entry flows to the kitchen, utility room, dining area and family room. Home office with French door entry. Island kitchen with built-in seating space and a generous walk-in pantry. Open family room with three large windows. Primary suite offers a spacious bedroom, double door entry to primary bathroom, dual vanities, garden tub, separate glass enclosed shower and a large walk-in closet. Guest suite with full bathroom and a walk-in closet. An additional bedroom, bathroom and a utility room complete this design. Mud room just off the two-car garage.','','19','Perry Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Conroe Southwest','Central Gas','1','Lot 3 Block 3','Subdivision Lot','5505','Other','','1180','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Grand Central Park','','','Water District','2023','Builder'); --> New record created successfully